Division by zero when opening a report

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

Guest

Hi,

I get this division by zero when opening a report. It used to run alright
until about 3 months ago. The report is run on a quarterly basis. I noticed
that when I turn off the filter, the report no longer has that error but it
has too much information.

I have a filter in the report properties activated ([0-3 0-299 Bal] Is Not
Null Or [4-36 0-299 Bal] Is Not Null Or [36+ 0-299 Bal] Is Not Null). The
report is pulling its information from a query which contains these fields.

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

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

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

Do you have any idea why it stopped running? I'm baffled.....

Thank you,
Aaron
 
I would try changing the filter to:

Not IsNull([0-3 0-299 Bal]) OR Not IsNull([4-36 0-299 Bal]) _
OR Not IsNull([36+ 0-299 Bal])

....and see what happens.

Hi,

I get this division by zero when opening a report. It used to run alright
until about 3 months ago. The report is run on a quarterly basis. I noticed
that when I turn off the filter, the report no longer has that error but it
has too much information.

I have a filter in the report properties activated ([0-3 0-299 Bal] Is Not
Null Or [4-36 0-299 Bal] Is Not Null Or [36+ 0-299 Bal] Is Not Null). The
report is pulling its information from a query which contains these fields.

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

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

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

Do you have any idea why it stopped running? I'm baffled.....

Thank you,
Aaron
Click to expand...

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
Hi,

Sorry it took so long to respond back. The change did not help. It seems
like there might be something wrong with the data. When I run the report
with a previous table, it works. Currently, I'm trying to find out what data
could be affecting the filter.

Thank you,
Aaron

RuralGuy said:
I would try changing the filter to:

Not IsNull([0-3 0-299 Bal]) OR Not IsNull([4-36 0-299 Bal]) _
OR Not IsNull([36+ 0-299 Bal])

....and see what happens.

Hi,

I get this division by zero when opening a report. It used to run alright
until about 3 months ago. The report is run on a quarterly basis. I noticed
that when I turn off the filter, the report no longer has that error but it
has too much information.

I have a filter in the report properties activated ([0-3 0-299 Bal] Is Not
Null Or [4-36 0-299 Bal] Is Not Null Or [36+ 0-299 Bal] Is Not Null). The
report is pulling its information from a query which contains these fields.

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

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

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

Do you have any idea why it stopped running? I'm baffled.....

Thank you,
Aaron
Click to expand...

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
Click to expand...
 
Back
Top