var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Working Days Query....... where to start !
Im using access 2003 and 2 date fields.
I am try to do a query the will query some stuff just on working days i.e. Monday to Friday.
Can anyone point me in the right direct pls.
Thanks in advance
Assuming you have a Date field in the records/table being queried you could include a calculated field such using the Weekday function ie.
Weekday([DateField]) as DayNum
in the query, and the filter on this
WHERE WeekNo Between 3 AND 7.
or perhaps use this directly
WHERE Weekday([DateField]) Between 3 AND 7.
Assuming the optional argument FistDayOfWeek in the Weekday function is set to vbSunday or omitted.
Would that do it ?
consider using weekday() in your sql query