Results 1 to 3 of 3
  1. #1
    cree2me is offline Novice
    Windows 8 Access 2007
    Join Date
    Nov 2014
    Posts
    3

    Adding to Counts

    Hello,



    I have to Count(s) on my Report Footer. Count([Attending]) and Count([Guests]) which work fine. How do I add these two Counts for one total on the report footer?

    Thanks in advance.

    Glen

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    off the cuff
    = Count([Attending]) + Count([Guests])

  3. #3
    cree2me is offline Novice
    Windows 8 Access 2007
    Join Date
    Nov 2014
    Posts
    3
    Thank you very much for your quick reply and solution! It works fine.

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

Similar Threads

  1. Numbers with sub counts
    By Thompyt in forum Access
    Replies: 8
    Last Post: 10-28-2014, 06:33 PM
  2. Why Are Counts Different?
    By johnywhy in forum Queries
    Replies: 9
    Last Post: 01-08-2014, 05:35 PM
  3. too many counts!
    By Svear in forum Access
    Replies: 1
    Last Post: 03-07-2012, 10:14 PM
  4. Counts in reports
    By beejay101 in forum Reports
    Replies: 2
    Last Post: 05-16-2011, 11:02 PM
  5. sql for grouping and counts
    By TheShabz in forum Queries
    Replies: 2
    Last Post: 11-04-2010, 02:01 PM

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