Help with update Query

  • Thread starter Thread starter Spidey3721
  • Start date Start date
S

Spidey3721

New to update queries here...

I have CostCodeID field (text format) that has all 6 digit numbers with a
"C" in front of them - I want to remove the "C"

I am trying to do an update Query that includes this field and has the
update to: line set to "= Right([CostCodeID], 6)."

Am I way off base here ?
 
NEVERMIND - must have had a minor type-o in there - It worked as shown
below
 
You must log in or register to reply here.

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

Update primary key field with multiple "where" clauses 0
DSum update query with multiple fields 0
Update query issue 0
Update query. Within the same table: populating field 2 from field 6
Query Question 2
Update query to format part numbers 3
Help required in Update query 2
Counting multiple memberships 1

Back
Top