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
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