Convert Text

P

Pass-the-reality

How do I change my field SAN from text to a number field within the query?
 
K

KARL DEWEY

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])
 
J

John W. Vinson

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
Format 2
multivalued field convert to text 1
convert from text to date 1
Can I convert a date to text? 6
convert number to text 4

Top