I have a table called "Expenses" with an autonumber field "Expense ID". In the "Format" property of the "Expense ID" i have set it up as "EXP"000#. So my numbers look lke this: EXP0001, EXP0002, EXP0003.
Now, I have a query that updates that "Expense ID" number to another table. But when I run the query, all I get is the number, not the format text with it.
So in the new table my numbers look like: 1, 2, 3.
Is there a way to get Access to copy the numbers with the text format?
Thanks in advance for any help