Total Column (1 Viewer)

Purdue15

Registered User.
Local time
Today, 03:29
Joined
Jun 12, 2013
Messages
29
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

Super Moderator
Local time
Today, 10:29
Joined
Nov 30, 2011
Messages
8,494
Why do you want the Criteria? You are if I am correct using only Count right?
 

Purdue15

Registered User.
Local time
Today, 03:29
Joined
Jun 12, 2013
Messages
29
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

Super Moderator
Local time
Today, 10:29
Joined
Nov 30, 2011
Messages
8,494
Can you show your Query? As I have no idea what data you have in the table the numbers you presented means absolutely nothing..
 

pr2-eugin

Super Moderator
Local time
Today, 10:29
Joined
Nov 30, 2011
Messages
8,494
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..
 

Users who are viewing this thread

Top Bottom