Convert Text

  • Thread starter Thread starter Pass-the-reality
  • Start date Start date
Why would you want to? Are you planning on adding two together or
multiplying them?
If you really must then to convert to long integer --
CLng([YourField])
 
How do I change my field SAN from text to a number field within the query?
Click to expand...

Use the Val() function:

SANAsNumber: Val([SAN])

in a vacant Field cell will return a Number datatype appropriate to the field
data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link Tables 5
Convert Numeric to Text Fields, Help!!! 5
Convert a memeo field to a text field 6
How to validate time format from a text field? 2
Format 2
multivalued field convert to text 1
How to convert a .msg File? 2
convert number to text 4

Back
Top