Queryare there with him him in the

[amerifax]

I am trying to create a quarry 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 vale within "PropertyDescription_1".

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

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 ever other day or so.

I hope you can help
Thanks
Bob

 

[amerifax]

Sorry about the Title. I must have had my mic on. I use Dragon. I can't find a place to edit. It should be "Quary".

Bob