Non Zero Formula

[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.

 

[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.

 

[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
(e-mail address removed)

 

[ladybug via AccessMonster.com]

THANK YOU!

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

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

[quoted text clipped - 3 lines]

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

 

[ruralguy via AccessMonster.com]

You are very welcome.

THANK YOU!

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

[quoted text clipped - 3 lines]