report has duplicate records

[iberger]

possibly you could assist in resolving a duplicate records problem with our database.<br><br>I think the record source in the report as shown below is the cause:<br><br>SELECT * FROM [Instrument Index] INNER JOIN [I-020A Pressure Gauge] ON [Instrument Index].[Data Sheet Ref] = [I-020A Pressure Gauge].[Data Sheet];<br><br>You see each table has 9 records, yet the report print yields 81 reports.<br>

 

[Guest_imported]

what results do you get on a left or a right join?

 

[iberger]

I have no experience with the r/l joins, can you email me directly? <A HREF="mailto:iberger@lg.com">iberger@lg.com</A>

 

[DougP]

Yes it is your Join<br>Try mkaing a new &quot;query&quot; and play with it to see if it will return the correct number of records.<br>then copy and paste the SQL code the query makes into your code.<br><br>OK <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[Guest_imported]

No I can't e-mail you directly one purpose of this forum is to assist others. Direct e-mail deprives others of a possible solution to a similar problem. If you just change the word inner to left them view the query results and then change it to right.