Why are there duplicates in my query results?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Atoliver25 said:
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
Click to expand...

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.
 
Back
Top