grouping on Month and year

  • Thread starter Thread starter Alex H
  • Start date Start date
A

Alex H

I have a table with a date field in ddmmyy. I need to extract a couont of
the number of records for each month and year - eg May 2005, June 2005 etc.

Is this possible please

Thanks
A
 
Alex

Look into Access HELP on the Month() and Year() functions. You'd use
Month([YourDateField]) in one query field and Year([YourDateField]) in a
second, then GroupBy (totals query) these two and use the Count for a third
(perhaps on your recordID field).
 
Thanks Jeff

Alex


Jeff Boyce said:
Alex

Look into Access HELP on the Month() and Year() functions. You'd use
Month([YourDateField]) in one query field and Year([YourDateField]) in a
second, then GroupBy (totals query) these two and use the Count for a
third
(perhaps on your recordID field).

--
Good luck

Jeff Boyce
<Access MVP>

Alex H said:
I have a table with a date field in ddmmyy. I need to extract a couont
of
the number of records for each month and year - eg May 2005, June 2005 etc.

Is this possible please

Thanks
A
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Range 2
grouping quarters 3
Totals for month and year 4
Setting the month format in a quert 2
Grouping on a date field 2
using date function to extract the actual day of the week 3
Excel Vba to change displayed year automatically. 14
Extract data within past 2 years of todays date 1

Back
Top