Query with duplicates

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

Mike O'Brien

In your union query use UNION ALL instead of UNION, i.e.,
SELECT LastName FROM Class1 UNION ALL SELECT LastName FROM
Class2

HTH

Mike.
 
Top