count in a query

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
 
M

Marshall Barton

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]
 
Top