Help with criteria for an updatequery

M

Mattias

Hi

I need help with the criteria for my update query.
Ex: I want to set the value 1 in a numberfield for every record that starts
with the data "xxxxx" as the first five letters in a text field.

Thank you in advance

Mattias
 
R

RandyInMass

Try using the following in the criteria portion of the field containing the
selection criteria, use

Like "xxxxx"
 
D

Duane Hookom

Set a criteria in a calculated column:

Field: NewColumn: Left([A text field], 5)
Criteria: "xxxxx"
 
M

Mattias

Thank you for your help ..it works great!!

Mattias

Duane Hookom said:
Set a criteria in a calculated column:

Field: NewColumn: Left([A text field], 5)
Criteria: "xxxxx"
--
Duane Hookom
MS Access MVP


Mattias said:
Hi

I need help with the criteria for my update query.
Ex: I want to set the value 1 in a numberfield for every record that
starts
with the data "xxxxx" as the first five letters in a text field.

Thank you in advance

Mattias
Click to expand...
Click to expand...
 
Top