Select query showing duplicate records

[pepperca]

I am doing some work on an Access 2000 database. I have 3 tables which are linked by a field called orderid.
I need data from all 3 tables. The results of the query list each record twice. I have tried the query propertied Unique Values and Unique Records but it still displays the same record twice. Note: If I only use 2 of the tables the data is correct, it is only when I pull the 3rd one in that I get duplicates displayed.

I would appreciate any help.

Cindy

 

[KenReay]

Hi

This suggests that the third table has two records for each Order Id

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove upper case to use