Selasa, 27 September 2011

[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
>

__._,_.___
Recent Activity:
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar