Remove First 4 Digits of Record 1

[medreports2]

I have an Access database, with a field "Model Number". I need to remove the first 4 didgits of every record in this field. I'm having some difficulty with the syntax of the left or trim functions to complete this task.

The answer is so simple, its going to drive me nuts, Please help!

 

[PHV]

Something like this ?
SELECT Mid([Model Number], 5) As NewModel FROM yourTable

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[medreports2]

Thanks! I used an iteration of this, but I got what I needed to solve my problem. Thank you very much!