converting text to %

  • Thread starter Thread starter Ted
  • Start date Start date
T

Ted

i know this is not hard...i've done it before but i'm drawing a blank

if i have a field: ConDedAmount which holds a value of 5% as text how do i
(in a query) pull the value as a percentage or decimal?

TIA
Ted
 
You can try an expression like:
Val(ConDedAmount)/100
This depends on the consistency of your data values.
 
Ted said:
if i have a field: ConDedAmount which holds a value of 5% as text how do i
(in a query) pull the value as a percentage or decimal?
Click to expand...


Val(ConDedAmount) will return the number 5. If you want the
decimal, divide by 100.
 
Back
Top