Right off hand, I would guess spelling error or missing table reference. If
you have more than one table in the query with the name of the field(s),
you'll need to specify the table (i.e., [table1].[diviser]). Although, if it
was a spelling error, I would expect the query to prompt for the item as a
parameter. Another possibility is that Name is a reserved word and should be
used as the field name.
--
Wayne Morgan
Microsoft Access MVP
"bart van deun" <vd*@pandora.be> wrote in message
news:oV**********************@phobos.telenet-ops.be...
Hello,
i have a problem with a division by zero fault in my report trough a
query...
this is the expression in the query:
Name: Sum(IIF([diviser]=0,0,[fieldA]/[diviser]))
what is wrong with this expression?
(the query says: the expression has a illegal number (0,0,)
thank you!