Problems with data types

S

Steve

I have a query that looks to add fields from two separate
spreadsheets. The query does add the figures together
properly, however, when it writes the output to the
destination table it changes the data type to text. As a
result, I am unable to manipulate the field.

I have tried changing the data type of the field in the
detination table to number, however, this reverts to text
as soon as i have re-run the query.

Any ideas ?

Thanks in advance
 
D

Dan Artuso

Hi,
There are two functions you can use to force a number:
CInt() and CLng()
Perhaps these will help?
 
Top