Query Help

[Frank Stone]

Try losing the brackets around the location.
Try using ... >= Location1 and <= Location2.

-----Original Message-----
I have a table that has various locations such as A01-01,

A01-02, A01-03 ... Z99-99. I am trying to only pull a
range of the locations so that I can update another field
based on these locations. I am using an IIf statement
such as ex. If([Table Name]![Field Name] Like "V[00-10]*"
And [Table Name]![Field Name] Like "SHIPPING",3505,. I am
usins the "V[00-10]*" to capture all the locations from
V00-00-* to V10-99-*. However, the quiery is updating all
locations begging with V. Am I missing something or is
this correct.