Report structure

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report from a query that contains a many to many to many relation
ship. One Site can have many CallSigns and many Freqs. A Freq can have many
Sites and CallSigns and so on. I have link them together with a table that
manages the many to many by creating 3 seperate one to many. I'm trying to
create a report that will provide a solution like this:

Site name:
CallSign 1:
Freq1, Freq2, Freq3
CallSign 2:
Freq1, Freq2, Freq3

I have tried to use some of your suggestions with in the form to create a
subreport and use colums But every time I do it the data colums include the
Site name and Callsign and make the report worst then just:
Site name:
CallSIgn:
Freq1
Freq2
Freq3
All three fields are primary keys How can I create a report to look like
above. Can I send your my mdb to see if you can get it to work?

Thanks
Tim
 
If the columns contain the SiteName, remove it. I assume your main report
should be based on unique Sitenames and CallSigns. The subreport should have
just the Freqs displayed in multiple columns that display across then down.

If you can't figure this out, there is another code alternative that
concatenates multiple "child" values together. The function with sample
usage can be found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane
 
Thanks that helped. I was able to use a subreport. I had to Change a couple
of tables.

Tim
 
Back
Top