View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dcbrown428
 
Posts: n/a
Default query criteria question

I need to set up a query that will pull all records that have a reservation
but no contract. In my table I have a column named "reserved date" and one
for "contract date". For this query I am trying to determine the records
that have an outstading reservation so I need to disqualify any that have a
contract date. How would I go about doing this?

By the way, my project is near completion and I really appreciate all the
helpful info I have been able to receive with the help of the "brains" who
answer all these postings. Thank you!