"overflow" in graph.

[Fuga]

I want a form with a graph on it.

The "graph-data-field" is a calculation on two other fields in the same query, calculating the difference (%) between them:
(([Field1]-[Field2])/([Field1])*100)

When I use the wizard to create the graph there is an overflow message. That can´t be right, can it?

Does anyone know what I´m doing wrong?
How do I round of the decimals in the calculated field (if that´s the problem)?

Fuga.

 

[Peter D]

If Field1 is 0, you'll get an overflow.

You may need special coding to account for this situation. Ex.:

IIF(Field1=0,<do this>,<else do this> )

Hope this helps,

Peter De Baets
Peter's Software - MS Access Tools for Developers http://www.peterssoftware.com

 

[Fuga]

Thanks Peter D!

I had some "0" and even some nulls. I solved it by excluding those records from the query.

However, when I create another graph from the same query (with only one field, not calculated) I get an "out of memory" message.

The thing is I built a similar db once before, and I never got this problem.

Any ideas?

Fuga.