First Day of the week

J

Jealthtoru

I'm doing a query were I sort by date using the following criteria:
Format ([DATE],"ww-yyyy") but my problem is that acces is sorting the week
starting Sunday and I need it to sort starting Monday. How can I change this?
 
F

fredg

I'm doing a query were I sort by date using the following criteria:
Format ([DATE],"ww-yyyy") but my problem is that acces is sorting the week
starting Sunday and I need it to sort starting Monday. How can I change this?
Click to expand...

The Format function has arguments.
Monday is vbMonday in VBA, (2) in Access and Queries.
Look it up in Help.
So in a query...
Format([DateField],"ww-yyyy",2)
 
Top