Terence,
thank you. that worked.
Jim Wagner
________________________________
________________________________
From: Terence <buffalome90210@yahoo.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, September 27, 2011 12:48 PM
Subject: [MS_AccessPros] Re: Convert a number in a text field to a number in a number field
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
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar