Grouping By Week

[SDS100UK]

Hi,

Is it possible to get CR to report on an Access query which will have upto 5 weeks of information in, in CR I would then create a crosstab on the date but what I want is the data grouped by the 4 or 5 weekly totals made up of the corresponding information from the complete query.

Does this make sense?

Hope someone can help me!!

TIA

Steevn

 

[BradB]

In your Crosstab, choose a column based on Date. Click on Group Options, then click the tab at the top labeled Specified Order. You can create your four or five week groups there. There should be some examples in the help on Specified Order. I hope this helps.

Brad Boydston
bboydston@bertnash.org