Sum of Counts from a query

G

Guest

I have created 3 queries that provide a count of all the records within my
table that meet specific criteria. I would like to have my query show just
the total number of records. The fields are Name/Address #1, PNC Card Nbr,
Date Mail Returned, and Date Card Mailed to Customer. Under the Name/Address
#1 field I have the Total row set to "Count". All other fields are set to
"Group by". When I run the query I get a field titled "CountOfName/Address
#1" with a row entry for each record that meets my search criteria. I just
need a total number to records that return for my search. Any suggestions on
how I might be able to do this?
 
G

Guest

It is giving you a count of every combination it is finding.
Remove PNC Card Nbr, Date Mail Returned, and Date Card Mailed to Customer
from the query grid.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Calculate sum of a field within the query 1
Counts of dates and sum of sales by month 2
counting Null fields 3
Running Sum in Query for Count Field 0
Filter by sum of counts 12
Need Help with Totals Query 24
Running Sum in query 1

Top