Week number in a year

[Pele]

Each week in a year has a number from 1-52.

I am trying to create a field in a query such that for a
date like 3/14/2004 the field will show the week number.
The WEEKNUM function in Excel does this but I don't know
the corresponding function in Access to do this.

Pele

 

[Rick B]

Use datepart

I think it is...

DatePart("w", [Somefield])

Hope that helps,

Rick B

 

[Rick B]

oops. It is "ww" not "w"

Rick B