From date to Date

[chazcoral2]

I have 16 people that enter about 50 entries per day. As they enter them they use a calander popup to enter the date in this format 00/00/0000 At the end of the month I want to run a report that shows each team members total for the month. How do I need to run the query to search from 4/1/2011 - 4/30/2011?

[jzwp11]

One way is to create an unbound form with two textbox controls and a button. You would use the textbox controls for the beginning and ending date of the period you want and pass that to a query. For the button, I would use the button wizard to open the query.

With respect to the query, you will first need a query to gather the correct detail records based on your date criteria; the query would look something along these lines (you will have to substitute your own field and table names)

query name: qryMonthlyDetail
SELECT person
FROM yourtable
WHERE yourdatefield BETWEEN forms!formname!startdatecontrolname AND forms!formname!enddatecontrolname

Then a query to do the counting

SELECT person, count(person) as CountOfThingsEntered
FROM qryMonthlyDetail
GROUP BY person