Solved

#func error ?

Posted on 2014-09-29
2
1,980 Views
Last Modified: 2014-09-29
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....
0
Comment
Question by:Rayne
2 Comments
 
LVL 24

Accepted Solution

by:
chaau earned 500 total points
ID: 40351494
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
 

Author Comment

by:Rayne
ID: 40351515
thank you Chaau
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now