Duplicate???

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

Guest

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??
 
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.
 
You must log in or register to reply here.

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

Access Auto Matching Duplicates? 0
Creating a report to merge 2 queries 2
working with Duplicates 2
query 4
Duplicate records - eliminate from totals 11
report using a subreport based on a crosstab query 5
Writing SQL code to delete duplicate records 0
Duplicate record work-around 2

Back
Top