The key is to design your report with the appropiate Sub-summary parts and then place summary fields for the totals in the right parts. But this will not work unless you have the data sorted in the same order that the parts are set up on your report. If I am understanding your setup: Your parts would be:

Year

Institution Type

Institutions (being the body)

The sort would be:

Year

Type

Institution

With these dang'd small reply boxes it is hard to follow your own logic.

Again the key is the sort has to follow the order of your parts. Play around with it and you will succeed.

I'm designing a database that stores co-op student placement statistics for numerous Canadian colleges and universities.

For the columnar reports, institutions are grouped based on type, with each group sorted alphabetically. A typical report lists various statistical totals (columns) per institution (rows).

I wish to set up a report that displays totals for different years, with each column representing a specific year. (Each record contains a "Year" field, but I can't figure out how to list *separate* totals in a report for different years.)

Any advice would be greatly appreciated!

[This message has been edited by mgrady (edited July 21, 2000).]

Mr mgrady,

I understand that you want the years in columns, If you proceed as geod suggested the sub-summary will devide the years in rows.

I foud a file that may help you, you can find it here: http://www.fmsearch.com/ , type "Excel-Like Matrix Report".

Hope it help you!

ZZ