Error Message Access Query

  • Thread starter Thread starter Peet
  • Start date Start date
P

Peet

I am busy with a calculation in a query in access and the
answer is "#error" how can I ged rid of the error message
i know in excel you can use the iserror function but how
about in Access.

The calculation is a simple % calc but some of the fields
contain zero's for values.
 
Are you dividing by zero? You may need to use an IIf statement in the
calculation.

IIf(Demonenator = 0, 0, Numerator / Demonenator)

This won't work in VBA, because VBA evaluates both parts of the IIf whether
it needs to or not, but in the query, only the true or false part is
evaluated as needed.
 
Wayne,

I hate those Demon --- enators when they are 0! :)

It's Denomenators!

Steve
PC Datasheet
 
PC Datasheet said:
Wayne,

I hate those Demon --- enators when they are 0! :)

It's Denomenators!

Steve
PC Datasheet
Click to expand...


< throat clear >
< sotto voce >

it's Denominators.

< g >
 
Back
Top