Select records based upon date

  • Thread starter Thread starter richard
  • Start date Start date
R

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