On Sat, 26 Feb 2005 16:24:03 -0500, Brian Keanie wrote:
I currently have numerical records in a text field. The numbers are really
text! If the number I have in a record is 12345 ....... how can I somehow
edit this to place "GP-" prior to the number? Please make the answer simple.
Best regards
To show the letters without actually changeing the data in the field:
="GP-" & [FieldName]
A permanent change?
Create an update query.
Update YourTable Set YourTable.[FieldName] = "GP-" & [FieldName];
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.