How to create WW (Work Week) field in query

[cheer]

How to create WW (Work Week) field for 1 year in query with Monday is first day and Sunday is last day of the week ?

 

[Guus2005]

The format command shows the week number

format(date,"ww")

Is this what you want?

HTH

 

[CBrighton]

If it's more that you want to have a query as a calendar and a field highlighting which day that date relates to I would suggest the Weekday function.

http://www.techonthenet.com/access/functions/date/weekday.php

:edit:

I think Guus has given you what you need but as you mentioned day numbers I provided this just in case.