Division By Zero Warning

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I need some help. I'm trying to run a report and am encountering this error
message. It seems that I when I turn off the report filter it works alright
but it shows more data than I would like it to show.

Report Filter:
[0-3 3-399 Bal] Is Not Null Or [4-36 3-399 Bal] Is Not Null Or [36+ 3-399
Bal] Is Not Null

The report pulls the fields from a query. This is the logic for those fields:
0-3 3-399 Bal: IIf(([RTM]>=0 And [RTM]<4) And ([APY]>=3 And
[APY]<4),[CurrentFace],Null)

4-36 3-399 Bal: IIf(([RTM]>=4 And [RTM]<=36) And ([APY]>=3 And
[APY]<4),[CurrentFace],Null)

36+ 3-399 Bal: IIf([RTM]>36 And ([APY]>=3 And [APY]<4),[CurrentFace],Null)

What the filter does is that it only shows records that have a balance. If
there is no balance then the record should not show. The filter worked
before but now it does not. The only thing that changed is that I imported a
new table and renamed the old one. The tables look identical. What is the
problem? I've been baffled about this for a while and really need help.

Thank you,
Aaron
 
My only suggestion would be to double check your data types in the new table
to make sure they match the old table.

Linda
 
Back
Top