Total Column

[Purdue15]

Ok now I have two tables in a query, I plan to use a couple of columns from one. Then for the rest of my columns I want the totals of each. So I have I clicked totals to show total and have clicked Count, then for criteria I have Is Not Null. I know this is simple but I cant seem to get it to work

 

[pr2-eugin]

Why do you want the Criteria? You are if I am correct using only Count right?

 

[Purdue15]

Yes but for some reason it counts the total number even if its blank, so if i have 34 rows the total for each column is 34 for each. instead of 30 31 28 34 etc..

 

[pr2-eugin]

Can you show your Query? As I have no idea what data you have in the table the numbers you presented means absolutely nothing..

 

[Purdue15]

The file is to large I cant

 

[pr2-eugin]

Okay, try the following suggestion..

To create a Sample DB (to be uploaded for other users to examine)..

1. Create a backup of the file, before you proceed..
2. Delete all forms/Queries/Reports that are not in Question (except the ones that are inter-related)
3. Delete auxiliary tables (that are hanging loose with no relationships).
4. If your table has 100,000 records, delete 99,990 records.
5. Perform a 'Compact & Repair' it would have brought the Size down to measly KBs..
6. (If your Post count is Less than 10 ZIP the file and) Upload it..