Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
query criteria question
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 "Dcbrown428" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AHHH! Again | Excel Discussion (Misc queries) | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
Database Functions - question using formulas as criteria | Excel Worksheet Functions | |||
Microsoft query criteria help | Excel Discussion (Misc queries) | |||
Question about Query Wizard | Excel Discussion (Misc queries) |