Hi; I cant beleive that I cant solve this one!!!
I have an update query and its going to update several fields based on parameters. Its all good and working fine except one field. Its the ID field, I just want it to update this field by adding the letter "R" before the ID number.
EX: if the ID field is "565" I want the query to update it to "R565". The ID field is a text field already.
Thanks in advance for any help.
I have an update query and its going to update several fields based on parameters. Its all good and working fine except one field. Its the ID field, I just want it to update this field by adding the letter "R" before the ID number.
EX: if the ID field is "565" I want the query to update it to "R565". The ID field is a text field already.
Thanks in advance for any help.