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?
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?