Error Message Access Query

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.
 
W

Wayne Morgan

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.
 
P

PC Datasheet

Wayne,

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

It's Denomenators!

Steve
PC Datasheet
 
K

Ken Snell

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 >
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

You don't currently have permission to access this folder 0
Solved Disk Full error message when exporting PDF 0
Calculate the median value before a specified list 0
Tweaking a calculated field in a query 4
Earned value (BCWP) showing as zero in chart 0
Calculations, Queries and making it all come together in my table 6
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Access 2016 Queries 0

Top