Query on Yes/No field

[Sjarko]

Hi,

I am very new to Access and still on a very steep learning curve. I have a challenge now that I need help with please. This is for a real estate company. I have two tables: Table "Buyers" that lists the requirement of the buyers and Table "Properties" that lists the features of the available homes. Field "Pool" is a Yes/No field where the buyer indicates if the property must have a pool.

The challenge is that if the buyer does not explicitly indicate that the property MUST have a pool, he may still like it if the property has a pool. So the query must only include the property if the property has a pool when the buyer definitely wants a pool, but include both properties with and without pools when the buyer indicated that a pool is not a requirement.

In summary: If Pool field Checkbox is checked, only select properties with pools. If Pool field Checkbox is unchecked, include all properties.



Many thanks for any assistance.

[Sjarko]

Problem solved. I figured it out. It was actually very simple.

[pbaldy]

Thanks for following up, and welcome to the site!

[Sjarko]

Thanks for following up, and welcome to the site!

Thank you very much.