query criteria question

D

Dcbrown428

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!
 
R

RogerN

I think that Autofilter should do the job easily. Just do ensure that ALL
your data has been selected as, if you have a blank row this will prevent the
autoselect function from selecting all the data.

Selectlect the "Non Blanks" for the "reserved date" column and "Blanks" for
the "contract date" column. I think I have gor that the right way round.

Roger
 
Top