Convert text to numeric

K

Karrie

The table that I am querying against is a numeric field
and in my results or make table query, I need this field
to be a text field. Any suggestions to make this change
in the query and not changing the format within the table
structure?

Thanks,

Karrie
 
G

Guest

Roger,

Thank you for your assistance. This will be a big time
savings. Thanks again,

Karrie
-----Original Message-----
Use the CStr function in the query:

StringVal: CStr([NumericField])

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

The table that I am querying against is a numeric field
and in my results or make table query, I need this field
to be a text field. Any suggestions to make this change
in the query and not changing the format within the table
structure?

Thanks,

Karrie
Click to expand...


.
Click to expand...
 
Top