Querying Several Criteria

[TClark14]

I hope someone can help with this query I am having difficulty with. The table I am querying has several expiration dates and Yes/No Fields
Listed below is what I need and the query needs to return the name and data if only one or all of the following applies

Name
"A Date" is before today
"B Date" is before today
"C Date" is before today
"D Date" is before today
"A Yes/No" = No
"B Yes/No" = No
"C Yes/No" = No

In other words, if all dates are = to today or later and Yes/No Fields are = Yes - I don't need them in the results.

I have tried this several ways using AND and OR but either way my results are ALL the records. not just the records that meet any or all of the above criteria. Maybe it's too much to ask? )

Thanks in advance for your help.

Terry

 

[MicroE]

See Attached

 

[TClark14]

Thank you, thank you, thank you!!!! That's perfect.

 

[MicroE]

You are welcome.