List all data that matches the criteria

[traycee]

Hi All!
I've been working on this problem all day and hope someone out there can point me in the right direction. I need a report to print out so that it looks similar to the following:

A. Media
1. Radio
a. # announcements 35
b. stations WHQL, WKOR, WQMA
c. language of stations Polish, Spanish, English
2. TV
a. # annoucements 25
b. stations CBS, Fox, Channel 13
c. language of stations English, Spanish

etc.

I have queries that show the correct data and I can get the total number of announcements in with no problem. I've got all the above and more listed in the page header, which gives me one page like a want, but it only lists the first station and first language instead of all of the stations and all of the languages. I don't even care if they run horizontally. Vertically would be fine to at this point. If I put the info above in the detail section, then of course I get station listed three times with each of the stations and same with language. But I don't need station or language listed 3 times. I just need station listed once and the 2 or more stations listed after it. Same with language. The two fields are [stations] and [languages]within a table called events. Why can't I get all of the stations and the languages to print?

 

[dhookom]

It would help if you gave us a hint regarding your data structure ;-)
It looks like you are rolling up your data into several different "aggregates". The easiest method for displaying this is to place each aggregate into its own totals query and display it in a subreport. Your main report would show only each unique Media with the number of announcements. You would have 2 subreports (possibly multiple column) that display Stations and Languages.

There is a generic function that would concatenate your stations or languages at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

Duane
MS Access MVP
Find out how to get great answers faq219-2884.