Match & Unmatch Query

[adambedford]

Is it possible to have a query that returns results that match some critera and that doesnt match others?

For example, a property rentals database search that matches the results of the "Bedrooms" field but not the "Date" field.

So the results are ones that are not marked as booked for the entered date, but they do match the number of bedrooms the user inputted.

Sorry if I'm not making much sense!

Thanks

 

[pbaldy]

Certainly; I'll post something on your other thread in a little while.

 

[adambedford]

Thank you very much!<br><br>Im having a go at it at the moment - I'm wondering whether I can combine the SQL of a regular query with a find unmatched one.<br><br>I have also attached a smaller version of the database I'm working on in my other thread incase its any use.<br><br>

 

[adambedford]

Thank you very much!

I'm having a go at it at the moment - Wondering whether it would work by combining the SQl of a regular query with that of a find unmatched one. Just a thought.

I have also attached a smaller version of the database I'm working with on the other thread incase thats any use.