Division By Zero Warning

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
 
L

Linda Burnside

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

Linda
 

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

Top