Numbers are stored in a string field in your database. To perform numeric calculations on this field, the data must be converted to a number. Which formula will correctly convert the data?

Question

Options

• AIf IsNumber ({Table.Field}) Then ConvertNumber ({Table.Field}) Else 0
• BIf IsNumber ({Table.Field}) Then ToNumber ({Table.Field}) Else 0
• CIf NumericText ({Table.Field}) Then ToNumber ({Table.Field}) Else 0
• DIf NumericText ({Table.Field}) Then ConvertNumber ({Table.Field}) Else 0

• A
  7% (2)
• B
  13% (4)
• C
  77% (23)
• D
  3% (1)

No community discussion yet for this question.