Update query: 5 digits to 3 (left)

A

annied

I have a column in my table that contains a 5 digit code (RBQ00) i want to
write an update query to change this code to the 3 first left digits (RBQ).
Can anyone help me with the syntex. I'm a bit new to this!!

Any help is much welcome.

Thankyou,

Annie
 
A

annied

Thanks 4 that.

Eric Blitzer said:
left([fieldname],3)



annied said:
I have a column in my table that contains a 5 digit code (RBQ00) i want to
write an update query to change this code to the 3 first left digits (RBQ).
Can anyone help me with the syntex. I'm a bit new to this!!

Any help is much welcome.

Thankyou,

Annie
Click to expand...
Click to expand...
 
Top