Duplicate lines in Access report

[Dave S]

I'm working on my first Access 2000 report, actually an invoice-type single
page print.

The detail lines are previewing and printing twice, each line repeats before
printing the next line twice.

Any thoughts on why and how to correct?

Thanks in advance.

 

[Duane Hookom]

Did you look at the datasheet view of the report's record source to see if
the issue is in your query?

 

[Duane Hookom]

Any responses should be posted to the earlier thread from Dave S.

 

[Dave S]

Thanks for that thought, I'll tell you what I see after I explain my further
findings:

There are 5 tables involved in the invoice print - Customer table has a
one-to-many relationship with Jobs table; Jobs table has one-to-many
relationships with 3 tables, Equipment, Functions and Notes.

The invoice print has Customer and Jobs fields in the header, they seem to
be fine. The detail section has a subreport for each of the 3 Jobs related
tables. here's what's actually happening as far as the "duplicates" are
concerned:

The three subreports repeat in groups, all three print then another set of
the three. The number of times they repeat is the product of multiplying the
number of records in each of the 3 tables as follows:

1 record in each gives 1*1*1 = 1 set of the 3 subreports - that's OK
Record counts of 2*1*1 = 2 sets of subreports print.
Record counts of 3*2*2 = 12 sets of subreports print!

Back to the record source - with record counts of 1/2/1 in the 3 tables,
record source displays 2 records with unique values in the fields from the
table with the 2 records and duplicate values in the 2 records from the
tables with 1 record each.

I'm sure this is probably something stupid that a newbie doesn't get yet
about relationships, joins or queries, but I greatly appreciate the
assistance,

Dave

 

[Duane Hookom]

The subreport is kind of a big part of your report and should have been
mentioned earlier. I expect your main report has the same level of detail as
your subreports. You may need to remove some of your detail table(s) from
your main report.