Count total records from a query

S

Shane

I have a query with 3 fields that have criteria's for
them and I need to return a value to a form that counts
the records that the query finds. Any help would be great.
Thank You
 
K

Kelvin

If all you need is a count, on your form you can use
DCount("[NameOfField]","NameOfQuery") as the record source for an unbound
text box.

Kelvin
 

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
Section and Page numbering 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
counting Null fields 3
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Split form 0
Using "Count" in Queries 2
QBF & Query Malfunction 0

Top