Convert text to numeric

  • Thread starter Thread starter Karrie
  • Start date Start date
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
 
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...
 
Back
Top