Results 1 to 6 of 6
  1. #1
    rscott7706 is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2009
    Location
    Lakeside Ca
    Posts
    24

    Placing count results only on a report

    I am sure this has been asked and answered. But when I do a search, no matter what criteria, I get hundreds of results. Please bear with me.

    I have several queries that I have selected the count totals. i.e - count Total members, Life, Subscription, A1, A2, etc.

    I want to list the totals only on a report, i.e.:

    Total Members: 1648
    Life: 1488


    Sustaining: 159
    A1: 168
    A2: 75
    A5: 4

    Can someone help on this?

  2. #2
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    So each one of those total values is a different query? You could maybe use DCOUNT function instead to get those counts instead of using queries. Then just add those to the report.

  3. #3
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Or make one union query joining all the totals queries and use that as your record source.

  4. #4
    rscott7706 is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2009
    Location
    Lakeside Ca
    Posts
    24
    Or is great if I were an Access guru. But, as a novice, I would appreciate if you would consider how to just add those to the report.

  5. #5
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Each query must look the same, as shown above they would have two fields called Description and DescCount (for example). Then create a union query, it is written in SQL:
    SELECT * FROM Query1
    UNION SELECT * FROM Query2
    UNION ELECT * FROM QUery3
    etc

    Create your report based on this query, use the wizard, it will set up all the fields for you.

  6. #6
    rscott7706 is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2009
    Location
    Lakeside Ca
    Posts
    24
    Thank you for your quick and helpful response. Much appreciated!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 04-15-2017, 11:09 AM
  2. Placing responses to parameters on report
    By Varda in forum Reports
    Replies: 3
    Last Post: 08-12-2015, 01:36 PM
  3. Replies: 7
    Last Post: 04-12-2014, 04:26 PM
  4. Replies: 1
    Last Post: 07-25-2013, 01:20 PM
  5. Placing a notes section in a report
    By lugnutmonkey in forum Reports
    Replies: 10
    Last Post: 03-05-2013, 11:50 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums