Using Like In An Update Query

[Arturo]

I have a table with Locations listed. When an order comes into the database
it is qualified by the Location table. The location, along with corresponding
fields, is then appended to an Orders table.

However, there are some orders that do not match up with the Location table
and I have no way of getting them to fit into that table because of factors
that constantly change. Once in the Orders table, I need to identify them.
All of these will start with the letter A or B and will be followed by the
number 1 thru 8. Examples are: A1, A2, B1, B2, etc. If it starts with the
letter A or B and is followed by the number 1 thru 8, I need to identify it.

How do I do that using Like in the criteria field of a query?

Thank you.

 

[KARL DEWEY]

WHERE ([Location] Like "A*" Or [Location] Like "B*" ) AND
(Right(Left([Location], 2),1) Between 1 AND 8)

 

[Marshall Barton]

I have a table with Locations listed. When an order comes into the database
it is qualified by the Location table. The location, along with corresponding
fields, is then appended to an Orders table.

However, there are some orders that do not match up with the Location table
and I have no way of getting them to fit into that table because of factors
that constantly change. Once in the Orders table, I need to identify them.
All of these will start with the letter A or B and will be followed by the
number 1 thru 8. Examples are: A1, A2, B1, B2, etc. If it starts with the
letter A or B and is followed by the number 1 thru 8, I need to identify it.

How do I do that using Like in the criteria field of a query?

Try using:

Like "[AB][1-8]"

 

[Arturo]

This looks like a SQL statement. I need something to put in the criteria
field of a query. Also Like "[AB][1-8]" did not work. I have to isolate the
first two characters only.

Thanks.

WHERE ([Location] Like "A*" Or [Location] Like "B*" ) AND
(Right(Left([Location], 2),1) Between 1 AND 8)

I have a table with Locations listed. When an order comes into the database
it is qualified by the Location table. The location, along with corresponding
fields, is then appended to an Orders table.

However, there are some orders that do not match up with the Location table
and I have no way of getting them to fit into that table because of factors
that constantly change. Once in the Orders table, I need to identify them.
All of these will start with the letter A or B and will be followed by the
number 1 thru 8. Examples are: A1, A2, B1, B2, etc. If it starts with the
letter A or B and is followed by the number 1 thru 8, I need to identify it.

How do I do that using Like in the criteria field of a query?

Thank you.

 

[Douglas J. Steele]

I have a table with Locations listed. When an order comes into the
database
it is qualified by the Location table. The location, along with
corresponding
fields, is then appended to an Orders table.

However, there are some orders that do not match up with the Location
table
and I have no way of getting them to fit into that table because of
factors
that constantly change. Once in the Orders table, I need to identify them.
All of these will start with the letter A or B and will be followed by the
number 1 thru 8. Examples are: A1, A2, B1, B2, etc. If it starts with the
letter A or B and is followed by the number 1 thru 8, I need to identify
it.

How do I do that using Like in the criteria field of a query?

Try using:

Like "[AB][1-8]"

Shouldn't that be

Like "[AB][1-8]*"

 

[Arturo]

That worked. Thanks.

I have a table with Locations listed. When an order comes into the
database
it is qualified by the Location table. The location, along with
corresponding
fields, is then appended to an Orders table.

However, there are some orders that do not match up with the Location
table
and I have no way of getting them to fit into that table because of
factors
that constantly change. Once in the Orders table, I need to identify them.
All of these will start with the letter A or B and will be followed by the
number 1 thru 8. Examples are: A1, A2, B1, B2, etc. If it starts with the
letter A or B and is followed by the number 1 thru 8, I need to identify
it.

How do I do that using Like in the criteria field of a query?

Try using:

Like "[AB][1-8]"

Shouldn't that be

Like "[AB][1-8]*"

 

[KARL DEWEY]

I see you got your answer but here is the criteria Location --
Like "A*" Or [Location] Like "B*"

AND you would also need a calculated field --
MyLocation: Right(Left([Location], 2),1)
with criteria --
Between 1 AND 8

Both criteria on the same criteria row in design view.

This looks like a SQL statement. I need something to put in the criteria
field of a query. Also Like "[AB][1-8]" did not work. I have to isolate the
first two characters only.

Thanks.

WHERE ([Location] Like "A*" Or [Location] Like "B*" ) AND
(Right(Left([Location], 2),1) Between 1 AND 8)

I have a table with Locations listed. When an order comes into the database
it is qualified by the Location table. The location, along with corresponding
fields, is then appended to an Orders table.

However, there are some orders that do not match up with the Location table
and I have no way of getting them to fit into that table because of factors
that constantly change. Once in the Orders table, I need to identify them.
All of these will start with the letter A or B and will be followed by the
number 1 thru 8. Examples are: A1, A2, B1, B2, etc. If it starts with the
letter A or B and is followed by the number 1 thru 8, I need to identify it.

How do I do that using Like in the criteria field of a query?

Thank you.

 

[John W. Vinson]

All of these will start with the letter A or B and will be followed by the
number 1 thru 8. Examples are: A1, A2, B1, B2, etc. If it starts with the
letter A or B and is followed by the number 1 thru 8, I need to identify it.

LIKE "[AB][1-8]*"

 

[Marshall Barton]

Arturo wrote: []

All of these will start with the letter A or B and will be followed by the
number 1 thru 8. Examples are: A1, A2, B1, B2, etc.

Try using:

Like "[AB][1-8]"

Shouldn't that be

Like "[AB][1-8]*"

That's what I was going to post, but I didn't see anything
that said there could be more than two characters so I
removed the *

Bad guess