DUPLICATE RECORDS IN QUERY

[CHICO]

I'M TRYING TO LINK TOGETHER THREE TABLES THAT SHARE ONE
COMMON FIELD (WORKORDER)IN A QUERY BUT I'M GETTING
DUPLICATE RECORDS. I'M NOT SURE I CAN GET THE RESULTS I'M
LOOKING FOR IN ONE QUERY. ANY IDEAS

 

[Phobos]

Is there something wrong with your Caps Lock key?

It's difficult to solve a problem without sufficient information, always
post your SQL.

That said, if it's a simple select query then use this syntax:

SELECT DISTINCT ...

P

 

[Duane Hookom]

If the 2 related tables aren't related to each other then you won't be able
display the records correctly in a single query. The display of data like
this can easily be handled in forms and subforms or reports and subreports.

 

[John Vinson]

I'M TRYING TO LINK TOGETHER THREE TABLES THAT SHARE ONE
COMMON FIELD (WORKORDER)IN A QUERY BUT I'M GETTING
DUPLICATE RECORDS. I'M NOT SURE I CAN GET THE RESULTS I'M
LOOKING FOR IN ONE QUERY. ANY IDEAS

First of, please don't SHOUT AT US. All Caps is hard to read.

Secondly, bear in mind: you know the structure of your tables and your
query; we don't. Clearly either your query is set up incorrectly, or
perhaps you have an incorrect expectation of what the query should
retrieve. Could you briefly describe your tables, identify their
Primary Key (if any), how the tables are related (if at all), and post
the SQL view of your query?