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

Howto make Delete query that keeps most recent 4
Query to display if multiple tests have been passed? 3
problem designing a query 4
text searching with select query 2
Query is not locating all records 3
Having a brainfart - Simple, but large query help? 5
Append query 5
2 autonumbers from 2 tbl's in 1 query 1

Top