Make table set field to number?

A

Andy

Hi I have a make table that is chopping up some date from
a bits blob into seperate fields. I have everything
working great except I need it to format them as numbers.
The make table keeps comming out in text. Can this be
done?
 
M

Marshall Barton

Andy said:
Hi I have a make table that is chopping up some date from
a bits blob into seperate fields. I have everything
working great except I need it to format them as numbers.
The make table keeps comming out in text. Can this be
done?
Click to expand...

It would be nice to see your query so we could suggest
specific modifications. Lacking that, all I can say is to
use the appropriate conversion function to convert from a
string to whatever type of number you need. E.g. instead of
a calculated field like expr1: Mid(somefield, 11, 6) you
could use expr1: CLng(Mid(somefield, 11, 6)) to convert the
string to a long integer.
 
Top