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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split data in field on character return 0
Query Know Thyself? 7
Populate a field with data, if it's blank 2
type conversion failure in append query 3
specifying data type in parameter queries? 2
Number to Number "Data Type Mismatch in Expression" in Join 1
data type for Make Table Query 1
Type Mismatch in Expression 4

Back
Top