L LG Sep 11, 2009 #1 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
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 Sep 11, 2009 #2 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]
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]
