Forum Discussion
wyptaj
Feb 02, 2022Copper Contributor
Convert Text to a number and 0 instead of #error
Hello Everyone, I'm sure this is an easy thing for all you experts, but I'm having a bit of trouble with this. I have a linked sql table in access, whereby numbers have been stored as text for ...
Feb 02, 2022
Hi,
How about this?
IIf(IsNumeric(bk_profit),Val(bk_profit),0)
Servus
Karl
************
Access News
Access DevCon
wyptaj
Feb 02, 2022Copper Contributor
Thank you both for your help, I really do appreciate it and they both worked. Thank you so much