Dates

[HOMMER]

I need to sum up volumes by weeks. I wrote the query but the problem is my company weeks do not match access start week.
Example 12/26/2004 - 1/1/2005 is week 53 in access but for my company this is week 1 for 2005.

 

[SkipVought]

Hi,

Add an offset value to each date to align with your definition of Week 1.

Skip,

_{[red]Be Advised![/red] The Vinyards of Texas have produced a wine with diuretic dimishment and urethric relief...
Pinot More!}

 

[HOMMER]

thanks works good