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
 

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

Division by zero when opening a report 2
calculations in my report 4
Report printing lots of identical pages. 2
Running Totals not working after zero cell 2
Can I set not to print detail section for null value? 1
Group in subreport 3
Make table query not returning value for expression 3
Print Lable base on Parameters 1

Back
Top