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.
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Grouping Names in Mail Merge 0
Help with Duplicate Output Alias Error 'Exp1' 0
Duplicates in union query 3
Duplicate hashtags in OneNote 0
ASK Field Formatting 1
SUM in a UNION query 2
Start a mail merge upon opening the document 1

Top