Hi, I am a fairly new user of Query so please bear with me.  I am trying to retrieve records with certain addresses.  I would like to use the Operator "one of" however when I try and list the values ie Bay and Baxter.  Nothing returns however I know there are records with those addresses within the database.  What is the syntax ie do I need "*" in front of Bay and/or is "One of" not the right operator. 

Thanks in advance.

N. 

I do not know if the * will work but try it and see.

 What you likely need to do is use the contains operator and do them separately

(Address contains Bay
OR Address contains Baxter)

Unfortunately using just the name, either way if the letters "bay" are in the middle of another street name like Bayview Dr. or Blue Bay Rd. they will also come up in this query.  You may want to be more specific in your contains and do "contains Bay Rd."  (hopefully they are all abbreviated the same or all spelled out.)

"One of" does not support wildcards.  You'll need to use multiple statements with on "OR" connector or merge multiple queries together.  In some cases, you may be able to write an expression containing wildcards that will work with the "Contains" condition.

Drew 

Make sure you are asking for Address Line 1 and try using the operator "contains"? 

T.