Iv'e always used the Val function
example
mynumber = Val("123") results in the the numeric equivalent.
Terence
--- In MS_Access_Professionals@yahoogroups.com, "luvmymelody" <luvmymelody@...> wrote:
>
> Hello,
>
> We have a download that gets imported into the database with fields that have numbers in them yet the fields data type is Text. Is there a simple way of formatting the text field so that the number is really a number? We need it to be a number so we can sum them.
>
> Thank You
>
> Jim Wagner
>
__._,_.___
MARKETPLACE
.
__,_._,___
Tidak ada komentar:
Posting Komentar