count in a query

  • Thread starter Thread starter LG
  • Start date Start date
L

LG

I have a query that I run by date(s) . How can I run a query to find out a
total of how many records were entered in that period.
Thanks
 
LG said:
I have a query that I run by date(s) . How can I run a query to find out a
total of how many records were entered in that period.
Click to expand...


SELECT COUNT(*) As NumRecords
FROM [your table]
WHERE [date field] Between [Start Date] And [End Date]
 
You must log in or register to reply here.

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

Combine Duplicates in Query 0
Count text values in a Access Field 0
Need Help with Totals Query 24
Dcount returning no results!!! 0
running total of records in query 1
Count and assign 2
counting Null fields 3
sum a count column in query 2

Back
Top