calculate week number

[northernbeaver]

I have a database that I have to determine if an employee worked overtime in a week, I have a table that records the date the employee worked and how many hours worked. I want to determine the number of each date in a seperate field. is there not a built in function that will tell you what week number a date is in Access 2003?

 

[PHV]

Format([date field], "ww")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244