Creating A Report From Multiple Tables/Queries

[muk5063]

I'm stuck on the final report of a soon-to-be complete db. Data from the following tables needs to go on a single report: 'Table1', 'DocsReceivedRev', 'CaseNotes' and 'Meetings'. The 'CaseNo' field is in 'Table1', to which the remaining three fields have a one-to-many relationship.

When creating a report, the records from each of the other tables are repeated (about 6 times). I tried to create a query and then a report from the query but got a similar problem.

Any help would be highly appreciated.

[June7]

Possibly need a report/subreport(s) arrangement.

'Table1' not an informative name.

[John_G]

You will have to use 3 sub-reports, one for each of the other three tables. Sub-reports work the same as sub-forms, in that you can link each subreport to a field on the main report to filter the data in the sub-report. In your case the link field is CaseNo.

[muk5063]

John_G and June7,

Thank you very much. The problem has been solved and it works like a dream.