Query Assistance

[access2010]

Can you please confirm that this Query is correct?
We would like to print all records if;
A = The Trade field contains any of these words = Buying, Purchased or Selling.
B = If the Trade field does not contain the above words or is empty, but the Investigate field contains Yes

Your assistance has been appreciated.

Nicole

 

[arnelgp]

i can confirm that it is correct (db on post#23)

 

[CarlettoFed]

Here you can see an example of a mask with dynamic filters.

 

[access2010]

i can confirm that it is correct (db on post#23)

Thank you ALL for your assistance.
I thought that this would have been a simple query to run.

Nicole