Group By Week Commencing

[Ally Bally]

I have a problem with grouping data to chart in a series of reports run automatically from a series of command buttons.

I need to show on the category axis "Week Commencing" dates but cannot find a way to obtain this data, it will let me use datepart to get week number or month or year. I have used datepart week to obtain the week number and then a table to lookup and convert the week number date but this has now failed as we crossed into the new year, all week 2 data now populates as if week 2 last year and the charts are screwed.

How do I group data by week, ie there are a series of jobs carried out daily which I need to group by week giving a total number of jobs and then use this info in a chart with the category axis set to the week commencing date.

I am beaten at present and getting much stick accordingly.

Thanks

 

[SydneyGeek]

Add another parameter to filter for the current year. For example:
New Field -- TransYear:Year([TransDate])
in the Criteria, Year(Date())
If this is to be used for charting, you will need to define the parameters. Do this: Query | Parameters. In the first column, enter the parameter (for example, Year([TransDate]). In the secons column, enter the data type.

Denis

 

[Ally Bally]

Thanks, I will try it.
Regards,

Alain