Dupulicate detail lines in Access report

G

Guest

I'm working with my first Access 2000 report, actually a single page
invoice-type document.

The detail lines on the page are previewing and printing twice, regardless
of how many lines are printed. Each line prints twice then the next line
prints twice, etc.

Any thoughts on why and how to correct?

Thanks in advance.
 
F

fredg

I'm working with my first Access 2000 report, actually a single page
invoice-type document.

The detail lines on the page are previewing and printing twice, regardless
of how many lines are printed. Each line prints twice then the next line
prints twice, etc.

Any thoughts on why and how to correct?

Thanks in advance.

You are probably using a query as the report's record source.
Check the query itself. Do you have each record duplicated twice
there?
You may have used 2 tables without establishing a relationship between
them. Join the tables and you will be all set.
 

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

Top