Define Mon as first day of the week.

N

Nick M

Hello,

I am running a query on sales visits per week when I noticed the 'default'
Access setting brings any sunday's date as the first day of the week.
I need to define Mon as the first day of the week. How should this be done?
I don't know vb and don't know how to get a module to work (my bad, never
needed it).

Speaking of vb. anyone have any good reference suggestions (other than the
'dummies' series)

Best Regards

-N
 
P

Pieter Wijnen

To set it for the database

Public Sub SetOptionsNorway()

With Access.Application
.Echo True, "Setting Database Options"
.SetOption "Default Open Mode for databases", 0 'Shared
.SetOption "First WeekDay", 1 ' Monday
.SetOption "First Week", 1 ' 4-day week
End With

End Sub

To simply use it in a query o.a use the Format & WeekDay Functions

HTH

Pieter
 
N

Nick M

I should have said, I need the entire week. Mon - Sun. will that remain the
same?
Best Regards
-N
 

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

Pivot table define Monday as first day of week 3
Finding the date of the first day of the week using "ww" to ID Wee 3
convert date to Day of the Week 2
Date for 1st day of the week 1
day of the week 3
Display First day of week 11
Calculate day of week in form & store in table 2
Showing date as day of week 4

Top