Division by zero when opening a report

[Aaron]

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

 

[RuralGuy]

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

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

 

[Aaron]

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

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

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