Need help with query

G

Guest

I have two patient tables. One has patients with a certain condition, and
the other has patients with a different codes. Some patients have both
conditions (so they will appear in both tables), and I want to find those
patients who are only in the first table and not the second table. I ran a
make-table query that shows patients who have both conditions, but I can't
figure out how to run a query to show only the patients who are in table one
but not table two. Anyone have any suggestions?

Thanks!
 

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

Query problem 6
Difference between to table and union 2
Update query error: "Operation must use an updateable query" 1
Multi-Value Field Query 0
Finding Duplicates 9
Query shows only one record 3
Add a new field that enters Y or N 1
Creating queries asking for counts 6

Top