I am sure this is in the lounge some place but I am not wording my search query properly.
This should be simple. I need to run a query based on a date range, that I know how to do
WHERE (((tblArcLightATSdata.SubmissionDate) Between [Start Date] And [End Date]));
What I need as an out put of the query is simply the total number of records that the query pulled from the data table.
i.e. Start Date = 09-01-2005 End Date = 09-30-2005 Result = 28 because in the month of September we had 28 resumes submitted.