Need to change Datatype Upon Retrieval

[bconner]

I have two tables that I am pulling into a Union query. One of the tables has the invoice number saved as text and the it is saved as a number. I have tried converting the data type however Access says there isn't enough memory to make the change. Is there a way I can convert the data type upon retrieval in a query without changing it in the table?

Any assistance is appreciated

 

[raskew]

Hi -

To convert a number to a string, use the Str() function:

x = 123
y = str(x)

To convert a string to a number, use the Val() function
z = val


HTH - Bob

 

[bconner]

Thanks a bunch!