I know this is wrong but can't quite see how to correct it
Track is a Numeric field currently holding 1, 2, 3 etc and I want to change to 1.1, 1.2 etc.Code:sql = "Update Tracks set Track = " & "1." & [Track] & " Where tID= " = c - 1
I tried VAL but didn't work. Access also gives error Microsoft Access can't find the field '|1' referred to in your expression.
Bit puzzled why it's showing the pipe character.