Format Text to Numeric Percentage

[DBFIN]

I have a text percentage that reads 28.0%. I want to convert to a numeric percentage that reads either 0.28 or 28.0%, preferably the latter. The Val function returns an error. How do I do this in a query ?

 

[jdraw]

What have you tried? What table and table design(s) is/are involved?

 

[DBFIN]

CDbl and Val do not work. Query reads a table, where Field is in text format like 28.0%.

 

[CJ_London]

Val should work - it will return 28.0 per your example so to convert to a decimal your calc would be

val(myText)/100

see this link

https://support.office.microsoft.co...28-bbe3-7ec14c6ab4d3&ui=en-US&rs=en-001&ad=US

You might want to explain what 'doesn't work' means