I have a calculated field in a query.

Calcfld: (([field2]/[field1])*100)

In order to avoid error I use the following statement in the criteria:

IIf(IsNull([Field1]);"0";([calcfld]))

I think this should mean "If field1 is null, then return 0 to calcfld, otherwise return the calcfld value".

The problem is I get an overflow. How should I write the criteria to do the trick?

Fuga.

Criteria would be the wrong place for this because the value has already been calculated. Try this as your field
Calcfld: IIf((IsNull([Field1]) Or [Field1]=0),0,([Field2]/[Field1])*100))

Thanks David R!

The query is now working. However, I would like to represent it graphically, but when I use the graph wizard, it´s not working at all.

When I create a graph without the wizard I get a message that one of the fields contains an invalid data type.

Since there are only two fields, one of which is a date field, I guess the problem lies in the calcfld.

Is the field really invalid?

How do I solve the problem?

I guess I could do a make table query, but is that really the correct way to go about it?

Fuga.