Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
  1. #16
    FranCorona is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    May 2013
    Location
    California
    Posts
    74

    Then I created the formulas in the report

  2. #17
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    To count Yes/No fields, use : =Sum(IIf(fieldname)=True,1,0) - this is counting the Yes's.

  3. #18
    FranCorona is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    May 2013
    Location
    California
    Posts
    74
    Thank you so very much!

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Adding Totals to Combo Box
    By adamjon92 in forum Forms
    Replies: 5
    Last Post: 02-25-2016, 02:36 PM
  2. Query for adding totals from several tables
    By rosscortb in forum Queries
    Replies: 7
    Last Post: 01-05-2015, 01:27 PM
  3. adding up totals in query
    By nightangel73 in forum Queries
    Replies: 3
    Last Post: 06-18-2014, 01:02 AM
  4. Replies: 1
    Last Post: 08-06-2013, 07:52 PM
  5. Adding Totals to a query using queryDef
    By jrickels in forum Programming
    Replies: 7
    Last Post: 04-06-2010, 07:47 AM

Tags for this Thread

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