Query with duplicates

  • Thread starter Thread starter catherine
  • Start date Start date
C

catherine

Hi hope you can help.

I have a tblTeacher set up with Autonumber as the Primary
Key. The problem I'm having with the query is that it is
pulling and merging (I also have a union query
established) the teachers who have the same last name and
are from the same school. Is there anyway to have them
list separately? Thanks for any help.
 
In your union query use UNION ALL instead of UNION, i.e.,
SELECT LastName FROM Class1 UNION ALL SELECT LastName FROM
Class2

HTH

Mike.
 
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

Duplicates in union query 3
Combine Duplicates in Query 0
merging 2 queries 3
Union Query to list duplicates 2
eliminating duplicate records in select query 1
Append query with recode 2
Multiple records in a query 4
Union query producing duplicate records 7

Back
Top