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.
 
Back
Top