Return Unknowns

[Ammodog]

I have racked my brain on this and hopefully one of you can help me. First of all let me explain what I am trying to do. I have a list of approx. 450 resturants that we need to collect taxes on every month. I have a table where all of the resturant information is stored. I have a table of transactions where we reciept in the voucher. I also have a table of the due dates. I'm trying to set up a query or a set of queries to give me a list of who has not turned in a voucher for a requested due date. I can generate a list of who has turned them in but I need one to tell me who hasn't for a certain date. This is probably really easy but my brain has died this week. Any suggestions? Thank you

Christopher Abney
There is no limit to the good you can do if you dont care who gets the credit

 

[lespaul]

select restaurantID, restaurantname from tblRestaurant where restaurantid NOT IN (put the query here that gets all the ones that have turned it in selecting only the restaurantID)

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

 

[PHV]

Have a look at LEFT JOIN.
You may also play with the unmatched query wizard.
Any chance you could post the SQL code of your query giving the list of who has turned them in ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Ammodog]

I got it, I had to build 2 queries per date, one to get all who have paid and then one unmatched query.This gave me a list who has not paid for that date. I know I could put the date in the criteria but I am using .asp web page to communicate with the data base. Thanks everyone

Christopher Abney
There is no limit to the good you can do if you dont care who gets the credit