Query Writing Question

P

pfm721

I have a db with 3 tables.

tblTracker
ID (AutoNumber) PK
VetSSN (text)
ConsultNumber (text)
Location (text)
tblVendor
Name (text) PK
Phone (number)
tblAppointment
ID (AutoNumber) PK
Type (text)
Status (text)
ConsultNumber (text)

My question is I would like to run a query that returns all consults that
don't have appointments. I am not sure how to build the query for this
though.

I woul
 

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

Problem with new entry on tabbed forms 2
why isn't this query FAST!? I've tried EVERYTHING! (query performance issue) 5
Questionnaire Query 11
How to append 1 table into 2 1
Trouble with Query Results 11
Further to.......Surely this must be possible?.. 6
No duplicates question 1
Adding a new record with a reference to another table 4

Top