Is there any way possible to 'trick' Access into thinking that the "ww" part of an expression such as:
WK: DatePart("ww",[ShftStrt],1)
where I am grouping my results by week would display as 1, 2, 3, 4 instead of 18, 19, 20, 21 as it would be, for example, 05-01-2006 thru 05-28-2006? I have...