#func error ?

Hello All,

As per this previous question:
http://www.experts-exchange.com/Database/MS_Access/Q_28527910.html

I am getting #func error in the middle column - what to i do to remove that like if error etc?

Please assist....
RayneAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
chaauConnect With a Mentor Commented:
Your data may not contain space in some rows, ie it has 28lbs.
These extended expressions will correct this:
size: Iif(InStr(1,[YourFieldName]," ")-1 > 1, Left([YourFieldName],InStr(1,[YourFieldName]," ")-1), [YourFieldName])
size denomination: Iif(InStr(1,[YourFieldName]," ") > 1,Right(Trim([YourFieldName]),Len(Trim([YourFieldName]))-InStr(1, _
 [YourFieldName]," ")), "")

Open in new window

0
 
RayneAuthor Commented:
thank you Chaau
0
All Courses

From novice to tech pro — start learning today.