QUERY

  • Thread starter Thread starter RK Anthony
  • Start date Start date
R

RK Anthony

I have two tables with some same data on some of the
fields. How dow I return the data from both tables
Without duplicates.
 
I have two tables with some same data on some of the
fields. How dow I return the data from both tables
Without duplicates.
Click to expand...

Create a Query based on the table; set the query's Unique Values
property to True.

Or if "duplicate" means duplicate on just part of the fields, create a
Totals query grouping by these fields. I don't know what you'll want
to see if only some of the fields duplicate and others don't!
 
Back
Top