Query - Multi Conditions

[amerifax]

I am trying to create a query which is totally new to me. I am including a picture that gives a better idea what I'm trying to do.

I'm drawing the value from field "PropertyDescription_1".

Note: The image shows lot as a field. That was a mistake "Lot" is a value within "PropertyDescription_1".

The condition is based on two fields.
PropertyDescription_1 (Field)
Contain Subd
Not Contain assessor,certified,parcel,CSM
Lot >2 (Lot has a space before number) Example:Lot Space 88

When building a query can you use a wildcard? One of our files has been scanned in so there are many misspellings within the field?

County Name (Field)
Contain Wash,Milw,Dodge

If the "Lot" value is a bit to much I can still make it work. It would be helpful. I have a database or Table with over 750,000 records. I would run this only every other day or so.

I hope you can help.

Thanks,

Bob

[SoftwareMatters]

Can you just clarify a couple of things:

Are "PropertyDescription_1", "Lot" and "County Name" different fields from the table State2010?

Do you want to add all the filters together at once?