Getting rid of Duplicates

D

DV

When I take two queries and put them together, without
using a join, I get a plethora of duplicates. Here's
what happens

Column1 Column2

Name1 Name4
Name2 Name4
Name3 Name4

Ideally, I would like it to look like...

Column1 Column2

Name1 Name4
Name2
Name3

Note: Even when using a join, I still get the same
problem.
 

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

Summing 1 or 2 or 3 values from 3 tables 5
averaging across columns 2
Conditional format or chart to show trend week by week 0
Query a table's particular column and return the field name. 3
Sorting the first text in a row 4
Rearranging data 2
Question about a unique list in VBA by checking data inside of 2 columns 1
what kind of query is needed? 5

Top