Adding a zero to a field

ChampionDuy

Registered User.
Local time
Today, 08:21
Joined
Mar 14, 2002
Messages
94
I just cant seem to get my update query to correctly update my field. I have a field called Case_No in a table called REVIEW. The case_no field is currently in this format 00-000. Where the first two digits are the current calander year and the last 3 are just a number that starts at 001 and goes up to 999 every time a new case is added. Well you guessed it I have reached my maximum case number for 2004. I am currently stuck at 04-999.
How can I update all my rows so that 04-999 will change to 04-0999, and 01-300 will change to 01-0300.

Any help would be appreciated, thank you very much.
 
UPDATE [TableName] SET [Case_No] = Left([Case_No],3) & "0" & Right([Case_No],3);

.
 
Thank YOU!

Thank you so very much, This Forum has really helped me in the past and now. Thanks again.
 

Users who are viewing this thread

Back
Top Bottom