Range Between A* and M*

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a large table that I am trying to Query a range of customers for. I
want to pull all customers that start with A and run through names starting
with M. I have tried the following:
= "A*" and <= "M*"
Click to expand...

but this excludes all customers starting with M such as Max or Murray. I
have seen examples using:

Between Like "A*" and Like "M*"

but I get the error "The expression you entered contains invalid syntax".
The table contains 100Ks of rows and the query result will contain about 52K
rows.

Any help is appreciated.

JohnV
 
Try this as criteria --
"N"
Click to expand...

JohnV said:
I have a large table that I am trying to Query a range of customers for. I
want to pull all customers that start with A and run through names starting
with M. I have tried the following:


but this excludes all customers starting with M such as Max or Murray. I
have seen examples using:

Between Like "A*" and Like "M*"

but I get the error "The expression you entered contains invalid syntax".
The table contains 100Ks of rows and the query result will contain about 52K
rows.

Any help is appreciated.

JohnV
Click to expand...
 
="A" And < "N"


Or
="A" and <= "Mzzzzzzzz"
Click to expand...

Or
Field: Left(CustomerName,1)
Criteria: Between "A" and "M"

The first two can use an index on the CustomerName field (and with lots of
records will be faster). The last cannot use the index.
 
I have a large table that I am trying to Query a range of customers for. I
want to pull all customers that start with A and run through names starting
with M. I have tried the following:
Click to expand...

Or

LIKE "[A-M]*"


John W. Vinson[MVP]
 
Back
Top