Conversion in Queries

[vbjohn]

Is there a way to make a string field into a value field in a query?


John-

 

[Rich]

CStr ?

 

[Fizzio]

I think it is Val rather than CStr. Doesn't CStr convert to a string? Alternatively there is CInt, CLng and CDbl.

 

[Rich]

Yes your correct Fiz, I've never had to convert strings, but You should use the data-type conversion functions instead of Val to provide internationally aware conversions from one data type to another. According to Help

 

[Fizzio]

Beautifully recited Rich

 

[vbjohn]

GREAT!

VAL() worked Great Thanks!!!!

 

[The_Doc_Man]

VAL works but watch out for cases where international differences occur.

For instance, what are your decimal and grouping punctuation markers for single or double greater than 1000 with fractional parts?

For integers, VAL is acceptable. But from a documentation & readability viewpoint, you leave out valuable information for posterity. Like, using CInt means you think the item will be limited to integer range but CLng means that bigger numbers could occur. VAL doesn't do any type of checking (other than that you have a valid number.)