We choose to use the same kind of numbering wherever numbering is used. We use three letters followed by six numbers i.e. "ABC"000000. Or in our Invoice purchase there may be a number INP002345. In the table where we setup the autonumber we enter "INP"000000 to return it as we want it. My invoices table has no problem when I create a query these numbers shows complete in the query. I then create a Union query. The problem I try to solve is the Union query does not display the full number. It shows the number without the prefix. I have a short cut fix but is there a easy way I am not aware of?