Convert Data Types

Hi, group!

I have a little problem when linking the following tables from Vantage 5.0
into Access:

Table Name - Field Name - Field Type
BOLHead - BOLNum - Type=number
ShipHead - Shiplog - Type=text

Does anybody know the formatting in an access query (or SQL) to convert the
number into a text? And by the way...if these fields are related, how come
are not both of them in the same format??? Thank you for any help.

Mario Aguirre
Lakin General
Ph: 773-871-9631
Fx: 773-871-1265

[Non-text portions of this message have been removed]