How To Stop the Duplication in Reports?

  • Thread starter malik via AccessMonster.com
  • Start date
M

malik via AccessMonster.com

Hi

Can anyone tell me that how can I Stop Duplication while running a Union
Query on a Repoert???

I have a Union Query which really duplicates the data.

Thanks
 
D

Duane Hookom

The "UNION" by itself should remove duplicates while "UNION ALL" will allow
duplicates. If you can't figure this out, you will need to come back with
more information about your data.
 
Top