How do I change my field SAN from text to a number field within the query?
P Pass-the-reality Feb 19, 2009 #1 How do I change my field SAN from text to a number field within the query?
K KARL DEWEY Feb 19, 2009 #2 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])
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 Feb 19, 2009 #3 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.
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.
