Duplicate???

A

Asta

i have created a report and using my 2 querys i've done earlier as my source
it matches up with 2 duplicate entrys and having only 4 all together.

Is a report suppose to search out each query and look which ones are the
same and then basically just show them?
and how do i get rid of the 2 duplicates??
 
S

SirPoonga

Add DISTINCT to the SQL version of the query. Or in query builder
gotot he query properties (right click the upper left box of the query
builder) and set Unique Values to Yes.
 
Top