Val() Function (?)

[croy]

In the Help file for Access 2002, I find this explanation
for the Val function:


"Returns the numbers contained in a string as a numeric
value of appropriate type."


I understand it up to the point of "appropriate type".

What does that mean?

Thanks,
croy

 

[Stefan Hoffmann]

hi,

I understand it up to the point of "appropriate type".
What does that mean?

It's about the string represention of numbers, e.g.

Val("16") = Val("&H10") = 16

Val() can handle


mfG
--> stefan <--

 

[John W. Vinson]

In the Help file for Access 2002, I find this explanation
for the Val function:


"Returns the numbers contained in a string as a numeric
value of appropriate type."


I understand it up to the point of "appropriate type".

What does that mean?

It means that Val("16") will return an Integer 16, whereas Val("16.255") will
return a Float 16.225.

 

[croy]

It means that Val("16") will return an Integer 16, whereas Val("16.255") will
return a Float 16.225.

*Now* I understand. Thanks John.