Help with criteria for an updatequery

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

Guest

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
 
Try using the following in the criteria portion of the field containing the
selection criteria, use

Like "xxxxx"
 
Set a criteria in a calculated column:

Field: NewColumn: Left([A text field], 5)
Criteria: "xxxxx"
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with updatequery 3
copy value from one field to another in Update 2
Access Dcount (multiple criteria) 3
Access: How to get autoID in updatequery after insert query 3
Help with code 2
Find and Replace Criteria 3
Help with an updatequery! 2
All-Record criteria in a query...hmmm 4

Back
Top