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 ?
 
Back
Top