Update Query help

ggodwin

Registered User.
Local time
Today, 07:46
Joined
Oct 20, 2008
Messages
112
I need an update query that will take a field and change the current format into what I need.

Currently the field structure is "##-QPR-***********"
I need to remove the "##-QPR-" for the records. (First seven records)

This is located in a table called
table = eQprUpdate
field = QPR Number

I would like to have an update query (I think) remove these first seven digits. Does anyone know how I can do this?
 
John,
Is that in the SQL Update statement?
 
The SQL would look something like;
Code:
SELECT Right([YourFieldName],Len([YourFieldName])-4) AS Expr1
FROM TBL_YourTableName;
 
Thanks for the help on this issue.

I am using the below code to generate the number. in the Expr1 field
Code:
SELECT Right([QPR Number],Len([QPR Number])-7) AS Expr1
FROM eQprUpdate;

but how can I add it to my table into a blank field?
 
Try something like this;
Code:
UPDATE TBL_YourTblName SET TBL_YourTblName.TrimedField= Right([CodeBeingTrimed],Len([CodeBeingTrimed])-4);
 

Users who are viewing this thread

Back
Top Bottom