Week wise data

[kbsudhir]

Hi All,

I want to create a query to extract weekwise.
How to do this.

Please guide

Regards
Sudhir

[CreganTur]

Would something like a Crosstab query help you achieve what you're looking for? You can set it to show results quarterly, weekly, monthly, etc.

[kbsudhir]

I have more than 8columns. All I need is these data should be grouped weekwise.

Thanks
Sudhir

[OBP]

You can use the Format property with "ww" to cahnge a Date to a week Number and use that for grouping.