Multiple Sorts on one page in a report?

[mpeterson]

Hello,

I am trying to figure out if there is a way to display information in multiple different ways on the same report, we have financial data for departments in multiple tables sorted by category, division, fund, etc, is there a way to have a page on a report for each department and then have each sort such as:

Dpt 001

Dpt by Category
2012 2013 2014

Dpt by Fund
2012 2013 2014

Dpt by Div
2012 2013 2014

Dpt FTE Count
2012 2013 2014.



Dpt 002

Dpt by Category
2012 2013 2014

Dpt by Fund
2012 2013 2014

Dpt by Div
2012 2013 2014

Dpt FTE Count
2012 2013 2014.

Thanks

[June7]

You should explore the Sorting & Grouping features of report. Access Help has guidelines.

I don't know your data structure but displaying the years horizontally could be difficult to accomplish.