Week number

[kevcar40]

Is it possible t ohave access to start the week on a saturday
for example
week 1
sat
sun
mon
tue
wed
thur
fri
week ends on a friday

thanks

kevin

 

[John W. Vinson]

Is it possible t ohave access to start the week on a saturday
for example
week 1
sat
sun
mon
tue
wed
thur
fri
week ends on a friday

thanks

kevin

Sure. See the VBA Help on the date functions. For instance, in the Help for
DatePart:

interval Required. String expression that is the interval of
time you want to return.

date Required. Variant (Date) value that you want to evaluate.

firstdayofweek Optional. A constant that specifies the first day of the week.
If not specified, Sunday is assumed.

firstweekofyear Optional. A constant that specifies the first week of
the year. If not specified, the first week is assumed to be the week in which
January 1 occurs.

--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com