week number

  • Thread starter Thread starter Rob
  • Start date Start date
R

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?
 
Rob said:
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?
Click to expand...

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