Division by zero when opening a report

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.

On Wed, 7 Sep 2005 17:38:03 -0700, "Aaron"
wrote:

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.

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" wrote:

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.

On Wed, 7 Sep 2005 17:38:03 -0700, "Aaron"
wrote:

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.