Single Report from teveral tables with a single to many relationsh

G

Graham

Novice builder so be gentle ;)

Here is the problem. I have constructed a report that utilizes a main table
that has a one to many with other tables. And example would be Customer
database, linked to tables of sales contacts and notes. Pluse other tables
that have multiple records.

When a I generate the report, the Customer information will repeat for each
record in the sales contacts, notes, and other tables. Therefore, though I
wish to generate a single report with all information, I have 30 reports for
a single individual. I know I could, in theory, get it to stop by
incorporating everything into a single table, however that isn't practical
given multiple entries, contatcts, etc.
 
S

Steve

Hello Graham,

Create a report/subreport. Base the main report on your customer table and
base the subreport on a query that includes the other tables. Depending on
what data you have in the other tables, you may need multiple subreports.
For each subreport, be sure to set the Linkmaster and Linkchild propertoes
to CustomerID.

Steve
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show one report per customer if multiple sales 0
Access Sorting and grouping using multiple tables 0
Automatically create multiple reports from a single report 1
Report that selects a single record 3
Multiple lines from different tables in a report detail 3
Can't create a report from my query in Access 1
Multiple tables 1 report 5
Merge multiple detail records in a single control 3

Top