Reports duplicating rows of information

C

Charlie

Hi,

I have inherited an Access 2000 database. Whilst i am in the process of
bringing to a useable standard, it is producing an unusual glitch.

I have a form which is used for orders, which the data is subsequently used
for producing order forms and invoice sheets. At random times the Report
will replicated lines of data from one of the subforms. The data only
appears in the table once and I can only see this error on the forms
themselves.

I am bound to have many other queries as I have become used to using 2007.

Thanks in advance

Charlotte
 
M

M Skabialka

In your query designer, look at the links between tables. Are they
one-to-one or one-to-many?
They should probably be one-to-many between appropriate tables if duplicates
are showing up.
 

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

Form with tabs duplicating 1
Sub Reports Duplicating Data 5
Creating multiple reports 1
Duplicating lines in an Invoice Report 7
Generating Invoice Numbers In Reports/Queries 4
Image type. PNG Reports and Forms: Preview and Print 0
Tracking Use of Reports 6
UDTs (as was vb6) 113

Top