Results 1 to 14 of 14

Why do totals disagree?

  1. #1
    HelenWM is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    12

    Why do totals disagree?


    I have created a database for a Free Store at our Church. On the Membership table when I click totals I get two totals three numbers apart. I have a column showing if they are active with a yes or no response. When I filter, the total of the yes and no responses are three less than the total number of members. The difference is in the yes responses. Any suggestions?

  2. #2
    Bob Fitz is offline MS Community Contributor
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    1,675
    Can you post a copy of the db
    If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
    Not everyone can access an accdb, you may reach a broader audience by attaching in mdb format.

    Bob Fitzpatrick

    I have never failed. I have found a thousand ways that do not work!

    Microsoft Community Contributor Award (2011)



  3. #3
    HelenWM is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    12

    Why do totals disagree?

    Quote Originally Posted by Bob Fitz View Post
    Can you post a copy of the db
    Click image for larger version. 

Name:	2016-10-24.jpg 
Views:	16 
Size:	158.8 KB 
ID:	26209

    When I use the Total option on this page, I get two totals at the bottom of the page. When filtered the yeses are 3 less than the Yes members.

    I have checked and all members have a yes or no in the IsActive column and all yeses and nos are spelled and capitalized the same.

    Thanks for any help.

    Helen

  4. #4
    Bob Fitz is offline MS Community Contributor
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    1,675
    Can you post a copy of the actual db
    If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
    Not everyone can access an accdb, you may reach a broader audience by attaching in mdb format.

    Bob Fitzpatrick

    I have never failed. I have found a thousand ways that do not work!

    Microsoft Community Contributor Award (2011)



  5. #5
    HelenWM is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    12

    Why do totals disagree?

    Quote Originally Posted by Bob Fitz View Post
    Can you post a copy of the actual db
    I have been trying to figure out how to copy the actual db without copying the data. I have not tried to do this before and am wondering if there is an easy way to do that. I will need explicit directions.

    Thank you for your patience.

    Helen

  6. #6
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    4,149
    1. create a new db
    2. use the import wizard to import tables/queries/whatever required to demonstrate your problem
    3. but before clicking OK to do the import click on the options button and select definitions only in the import tables section

    new db will then have empty tables

  7. #7
    HelenWM is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    12
    I have saved the db with the empty tables as directed. I know this is so elementary but having struggles with every step. Now how do I get it on this forum? It will not copy and paste or drag.

    Thanks for your patience!

  8. #8
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    16,185
    Click on "Go Advanced", then you'll see the attachments option.
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

  9. #9
    HelenWM is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    12

    Why do totals disagree?

    Database for Forum.accdb

    There is an error with the attachment that says: "The asset is not currently being used by any content that you have access to."

    I don't understand since I can successfully open the db on my desktop from that link.

    I think maybe this is getting too complicated for my abilities. I am taking too much of your time.

    I eliminated the part of the database that concerned volunteers since the file was too large to upload. There are no problems with that area of the database, just in "Members".
    Last edited by HelenWM; 10-25-2016 at 10:05 AM. Reason: Needed to give more info.

  10. #10
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2013 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    2,143
    I have never used the totals feature! All it is doing is counting the Yes's and ignoring the No's. I do all counts and data manipulation thru queries (at a minimum). People who are techies never use tables for anything except to store data - who knows what Access is doing behind the scenes! We would much rather control it ourselves. So do yourself a favour and do not depend on Access's handling of data, rather write simple queries which read, count, etc. so that you are in control.

  11. #11
    HelenWM is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    12
    Instead of using the totals feature, how would I write a query to ask how many are active using IsActive column. See database above.

  12. #12
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2013 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    2,143
    Queries also have the "totals" feature, the same Greek letter symbol, an icon at the top.

    I presume you can create a query to display data from a table? Then click on the Totals icon and you can sum, count, average, etc.

    Create a new query, then click on SQL view and copy/paste this:

    SELECT Count(MemberT.IsActive) AS CountOfIsActive
    FROM MemberT
    WHERE (((MemberT.IsActive)=Yes));

  13. #13
    HelenWM is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    12
    I am sorry for all the time I wasted for you. My totals are fine. The three short were zip codes missing.

  14. #14
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2013 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    2,143
    NP, happy to help.

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

Similar Threads

  1. Query detail totals vs. Summary Totals do not match?
    By aellistechsupport in forum Queries
    Replies: 9
    Last Post: 01-15-2016, 10:36 AM
  2. Similar to totals and Grand totals
    By Thompyt in forum Reports
    Replies: 14
    Last Post: 01-24-2015, 05:39 PM
  3. Replies: 5
    Last Post: 12-06-2011, 10:18 AM
  4. Month totals and Year totals
    By marksnwv in forum Access
    Replies: 1
    Last Post: 08-05-2011, 09:13 AM
  5. Replies: 3
    Last Post: 06-26-2009, 10:44 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
  •  
Tech Forums: Microsoft Office Forums