First Day of the week

G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

changing default starting day for week numbering in access 9
Get date for start of week 3
Display First day of week 11
Wrong week number 2
Pivot table define Monday as first day of week 3
Change starting day in week form 1
Week numbers 2
How can I set the first day of week to Monday in a pivotchart? 1

Top