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

Report only displaying some info 1
Creating a Report using Tables (that have no relationships) 0
Report with Single Subreport Printing Multiple Pages of Same Data 1
Single Report from Multiple Tables 4
Automatically create multiple reports from a single report 1
Sequentially print multiple tables/queries in single report 1
Merge multiple detail records in a single control 3
Report that selects a single record 4

Top