How can I convert Text to Numbers for a Report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to be able to convert Numbers that are stored in a Text Field in
my Table to Numbers to be calculated on a Report. Any possible way?
 
Hoopster said:
I would like to be able to convert Numbers that are stored in a Text
Field in my Table to Numbers to be calculated on a Report. Any
possible way?
Click to expand...

=Val([YourFiledName])
=CInt([YourFiledName])
=CDbl([YourFiledName])
=CCur([YourFiledName])
 
Thanks Rick. Val worked great!

Rick Brandt said:
Hoopster said:
I would like to be able to convert Numbers that are stored in a Text
Field in my Table to Numbers to be calculated on a Report. Any
possible way?
Click to expand...

=Val([YourFiledName])
=CInt([YourFiledName])
=CDbl([YourFiledName])
=CCur([YourFiledName])
Click to expand...
 
Rick,

Ok so I thought everything was working great untill I ran into Text
Value like .3125. I had been using =Min(IIf([Side Hem Width
1]="",Null,(Val([Side Hem Width 1])))) and all worked like I wanted it to
untill this. The Text this was working on was like 7.000 but for some reason
..31252 or .250 gives me the error "Data Type mismatch in Criteria
Expression". I guess I don't understand why it would take the 7.000 and not
the .250. Both are entered in my Table as a Text Value.

Hoopster said:
Thanks Rick. Val worked great!

Rick Brandt said:
Hoopster said:
I would like to be able to convert Numbers that are stored in a Text
Field in my Table to Numbers to be calculated on a Report. Any
possible way?
Click to expand...

=Val([YourFiledName])
=CInt([YourFiledName])
=CDbl([YourFiledName])
=CCur([YourFiledName])
Click to expand...
Click to expand...
 
Back
Top