Week number in a year

  • Thread starter Thread starter Pele
  • Start date Start date
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
 
Back
Top