Grouping for Saturday

[bez999]

Hello

I have an Access report that handles daily records which I am trying to summarise by week. The figures are correct but it always presents the figures using the Monday dates for any given date range that I use.

Is it possible to get it to use Saturdays instead?

I've tried changing the dayoftheweek parameter in the Format$ statement that the wizard put in my group footer line but it makes no difference.

Thanks.

Regards
Bez

 

[dhookom]

If it "presents the figures using the Monday dates " can't you just add 6 to the presented date to be the Saturday date?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]