Compare data from 2 querys and remove duplicates

[Technodruid]

Hello again,

I have a table with 4 fields DomA, Name, Domain, Account.

I have 2 queries made, the first pulls the records Based on a specific name in the domain field, so the data I have is DomA and Domain.

The second query pulls Does the Same only it excludes the records from the First query and it gives the Data from Account and Domain.

These are then sent to a text box on a form.

Sample:
DomA Domain Account
abc XXX abc
lrt XXX lrt
rst XXX rst

Account Domain DomA
abc elf who
acd cab arg
ijk cab why

What I need to be able to do is make sure that DomA and Account are not Duplicated.

I need to send the group below to the text box.
abc
lrt
rst
acd
ijk
I know this should be Simple But Its either duplicating the records, removing all the records or giving me totally unexpected results in the records it pulls.

A little information on the data, Domain is a list of Locations, the DomA and Account, are a list of account names. In Domain XXX DomA and Account are the Same, the rest of Domain the DomA and Account are different.

Is there a simple why to make sure I do not duplicate the output?

 

[llkhoutx]

Use a union query to select one column the records from the 2 tables, then query that union query, grouping so as to eliminates the duplicates.