week number

[Rob]

Quite a few databases ago, I remember using the week
number to group data for each week of the year. Now Ive
forgotten what I did, and I cant seem to find it in any
books or in the help menu. Does anyone know the format for
this?

 

[Arvin Meyer]

Quite a few databases ago, I remember using the week
number to group data for each week of the year. Now Ive
forgotten what I did, and I cant seem to find it in any
books or in the help menu. Does anyone know the format for
this?

Use the DatePart() function:

DatePart("ww",[DateField])
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access