Why are there duplicates in my query results?

[Guest]

I have a query using 3 queries?

In POS not in Store Query
In POS not in TechDesk Query
In POS not in Outside Sales Query

I need to have a datasheet or report pull the results from each of these
queries into one datasheet or report for review.

I get what I want however it is duplicated (4 of each result).

I need to know how to get the duplicates from showing so that the query can
be run and the results that show are without any duplication.

Any help would be appreciated. Thanks.

Ann

 

[MGFoster]

I have a query using 3 queries?

In POS not in Store Query
In POS not in TechDesk Query
In POS not in Outside Sales Query

I need to have a datasheet or report pull the results from each of these
queries into one datasheet or report for review.

I get what I want however it is duplicated (4 of each result).

I need to know how to get the duplicates from showing so that the query can
be run and the results that show are without any duplication.

Any help would be appreciated. Thanks.

Ann

Without seeing the query I can't really say.

A kludgey guess would be to use DISTINCTROW or GROUP BY to get rid of
duplicates.

 

[Guest]

I will try the DISTNCTROW. Thanks for the suggestion.