Reports with multiple groups

[Christey]

Hi, I am trying to pull a report that groups by every
field. Instead of pulling individual records, I want the
report to list each field, and all of the answers that
were given for that field. Like:

Rank:
Professor
Assistant Professor
Assistant Professor
Assistant Professor
Clinical
Clinical

# of children:
5
4
6
5
3
4

etc, please help! There are 150 fields, so it is a very
large database, I am wondering if I am going to have to
break it up in order to be able to pull a report like
this.
Thanks,
Christey

 

[Duane Hookom]

I think you have an issue with your table structure. This looks like a
survey type application. You might want to check out the At Your Survey demo
at http://www.rogersaccesslibrary.com/OtherLibraries.asp.