Non Zero Formula

  • Thread starter ladybug via AccessMonster.com
  • Start date
L

ladybug via AccessMonster.com

I have a report that has a field =[Target]/[TotalErrors]

I want if Target equals a positive # and total Errors equals 0 1000% is
returned.

How do I change my field to capture this. Currently I am returned in error
if this occurs.
 
R

ruralguy via AccessMonster.com

=IIF([TotalErrors]=0,10,[Target]/[TotalErrors])

I have a report that has a field =[Target]/[TotalErrors]

I want if Target equals a positive # and total Errors equals 0 1000% is
returned.

How do I change my field to capture this. Currently I am returned in error
if this occurs.
Click to expand...
 
S

Steve

=IIF([TotalErrors] <> 0,[Target]/[TotalErrors],10)

this presumes that your field is formatted as Percent. 10 will then give you
1000%.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]
 
Top