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

Automation of scanned file storage based on content 0
Form with tabs duplicating 1
Duplicating Reports 3
VLookup IF word in string exists within cell, use the word. 0
Sub Reports Duplicating Data 5
Auto populate fields in new form 5
VBA works in orignal but fails in copy of database 1
Meeting requests duplicating themselves in Outlook 2003 0

Top