Week number in a year

P

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
 
Top