Sum of Counts from a query

P

pncanalyst74

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?
 
K

KARL DEWEY

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

How to display zero value in blank fields of Cross Tab query 0
Insert name and adress from a list in a word document 1
Section and Page numbering 0
Display weeks from a Milestone 0
SUM in a UNION query 2
Calculate sum of a field within the query 1
Running Sum in query 1
query to show where no data in a stated column 0

Top