change data from text to numeric

  • Thread starter Thread starter brichler
  • Start date Start date
B

brichler

after using Instr() to select a number from a text string, I would like
to use Group By and Sum on this data. However, I am getting the old
"data mismatch in criteria expression" error, I think because my source
data is text, and the end result needs to be numeric.

what would you suggest?

thank you-
sarah
 
after using Instr() to select a number from a text string, I would like
to use Group By and Sum on this data. However, I am getting the old
"data mismatch in criteria expression" error, I think because my source
data is text, and the end result needs to be numeric.

what would you suggest?
Click to expand...

Use the Val function to convert the result of the Instr to numeric.

Tom Lake
 
Back
Top