Week of Year

  • Thread starter Thread starter Angus Crossley
  • Start date Start date
A

Angus Crossley

I want to sort records and report on them grouped according to the calendar
week they fall in. Is there a 'Week of Year' function or a way to calculate
this?
 
Try lookup Help on the DatePart() or Format() functions. You might need to
be in a code/module window to get the proper Help.
 
Many thanks, DatePart fits the bill perfectly.

Duane Hookom said:
Try lookup Help on the DatePart() or Format() functions. You might need to
be in a code/module window to get the proper Help.
Click to expand...
 
You must log in or register to reply here.

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

Year and Week Totals 2
Update Query Problem 1
Streaming boosts 16.5% rise in US recorded music revenues 4
Hello from Me. 5
Previous Week, Month, year, etc. 2
Crosstab Queries by week 2
how do I query daily records by week? 1
payroll weeks / varying first day and week of the year 2

Back
Top