Requery where source is a Crosstab

[Gustotangerine]

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 been asked to create something that would start with "week 1" no matter what month is chosen from the Form; then calculate Variance and Variance % by week. So, I need Access to believe that the lowest value in the weeks returned is 1 and then have each increase by 1 from there. Is this possible?

 

[ChopinFan]

I'm sure there's a way to do this, but I'd have to play with it. Even though you may have an ADP file, I recommend you post this in the Microsoft Access: Reports forum. It is much more active with people than this one!

 

[lameid]

When you do repost, you should post back your thread here... Also I am having trouble figuring what field your datepart is used on. I recommend posting the SQL for your query (or other object).