Select records based upon date

[richard]

Hi

I need to create a report which shows the number of samples received from
each client in each calendar month.
I need advice on the query to select the data by calendar month, each sample
has a date stamp on it which is the date I would use for the calendar month

Thanks

Richard

 

[Jeff Boyce]

Richard

Take a look at Access HELP for the Month() function. Note that if your data
covers more than one year, you'll want to also look into the Year()
function.

Regards

Jeff Boyce
Microsoft Office/Access MVP