Convert text to numeric

[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 Carlson]

Use the CStr function in the query:

StringVal: CStr([NumericField])

 

[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

.