Creating a quarterly report from a query

[chris0309 via AccessMonster.com]

Hi All,

Is it possible to create a quarterly report using a query within an Access
Database?

Thanks for any help, much appriciated.

Chris

 

[Allen Browne]

Is it possible to create a quarterly report using a query within an Access
Database?

In report design view, open the Sorting and Grouping box, and choose the
date field.

You can set the interval to Quarter, and the Group Footer to yes. This gives
you a group footer section, where you can place text boxes to give the
totals for the quarter.

 

[chris0309 via AccessMonster.com]

Thanks iv got that working, much appriciated Allen