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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to sync OL365 contacts and calendar to iPhone without iTunes? 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Making "Change Highlighting" feature darker 1
get Data Validation to stop, list supplied, duplicate data entries 1
Duplicates in union query 3
Duplicate Data showing on Report 20
Not Counting Duplicates in a Report 3
Phone notification 0

Top