Help with Expression

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

=IIf(Sum([Apps_PLow_Tract])=0,0,Sum([Denials_PLow_Tract]/
[Apps_PLow_Tract]))

the baove expression gives me Overflow error.

Please help !

Thanks,

Sumnesh
 
Are you sure you don't want:
=IIf(Sum([Apps_PLow_Tract])=0,0,Sum([Denials_PLow_Tract]) /
Sum([Apps_PLow_Tract]))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Report Average Miles/Gallon in Group Footer and Report Footer? 9
Access Query problem 1
show 0 in section footer if total is 0 2
Help with aggregate function 6
Printing in Group 1
Exclude records from footer calculations but include in detail sec 1
Is there a better way? 4
Using the IsError Function 3

Back
Top