Problems with data types

  • Thread starter Thread starter Steve
  • Start date Start date
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
 
Hi,
There are two functions you can use to force a number:
CInt() and CLng()
Perhaps these will help?
 
Back
Top