Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Nov 2002
    Location
    Toronto, Ontario, Canada
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    multiple query report (2000)

    I am trying to generating a report from a table that has multiple fields that are yes/no data type (check marks) . I have multiple queries that give the count of all the yes fields.
    But the report wizard won' t allow me to display these multiple queries on one report cause it says they are not related. but they are generated from the same table.

    The purpose of the report is to give me the count of records that have a check (yes).

    From each query I can generate a report that has the count for each individual field but I don't want to have 10 reports with 2 lines of information. I would like to have them display in one report.

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: multiple query report (2000)

    You have several options:

    1. Create a single query that collects all the information, and use this as record source of the report. You may be able to create it from scratch, or you can base it on the queries you already have.
    2. Do the counting in the report itself - you can use statistical functions like Sum and Count in the control source of text boxes in the report footer section (and group footer sections if you have them), and statistical domain functions like DSum and DCount in the control source of text boxes anywhere in the report.
    3. Create the separate reports, then create a blank new report (without record source) and put the separate reports into it as subreports. Not very elegant, but it might save time if you have already created the individual reports.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •