Replace #Error (1 Viewer)

B

bollie

Guest

• Feb 20, 2006

• #1

I have a query where I make a calculation. In some cases this calculation results in a division by zero. The field will then show #Fout (#Error in english?). I want to replace this message with something else, like a dash for example.

Can someone tell me how?

Thanks.

 

P

peterlee516

Registered User.

Local time

Today, 09:52

Joined

Nov 29, 2007

Messages

36

• Feb 12, 2008

• #2

Me too!

I'm also looking for the solution to that problem. Any luck?

 

boblarson

Smeghead

Local time

Today, 09:52

Joined

Jan 12, 2001

Messages

32,059

• Feb 12, 2008

• #3

Make a new field in your query with:

MYNewFieldName:IIf([YourDivisorField]=0,"-",[YourFieldToDivide]/[YourDivisorField])

 

P

peterlee516

Registered User.

Local time

Today, 09:52

Joined

Nov 29, 2007

Messages

36

• Feb 14, 2008

• #4

That worked perfectly! Thank you Bob!

 

boblarson

Smeghead

Local time

Today, 09:52

Joined

Jan 12, 2001

Messages

32,059

• Feb 15, 2008

• #5

Glad we could help