Week Number with MS Access query

Gord · Nov 20, 2003

I am using Access 2000 and I have a database containing a
number of dates in the form of mm/dd/yy. How can I run a
query that would separate these dates by the week?

Duane Hookom · Nov 21, 2003

Group by Year([DateField]) and DatePart("ww",[DateField])

Week Number with MS Access query

Gord

Duane Hookom