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
