07-20-2009, 02:05 PM #6 MSAccessRookie AWF VIP Join Date: May 2008 Location: Central NJ, USA

Test for 0. Access #num Error 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" wrote in message news:oV**********************@phobos.telenet-ops.be... Register Privacy Policy Terms and Rules Help Popular Sections Tech Support Forums Articles Archives Connect With Us Twitter Log-in Register Contact Us Forum software by XenForo™ ©2010-2016 XenForo Ltd. http://www.access-programmers.co.uk/forums/showthread.php?t=176338 I get 2 as my results but for February if Field A is zero and Field B is zero, i get and #error message therefore I can't calculate an average for

You may have to break out [AHT] in its own query. Access #num! So my reasoning was wrong when I worked it out in my head. If so, it replaces > the Null with a 0 in this calculation. In the US we use commas in both places, not semicolons. -- Wayne Morgan MS Access MVP "bart van deun" wrote in message news:PE**********************@phobos.telenet-ops.be...

Access #num Error

Test for 0. Since I believe that when you use IIF as > an expression in a control (as opposed to using it in a query) both the > True and the False argument Iserror Access Find More Posts by boblarson 07-20-2009, 03:06 PM #14 tebule Registered User Join Date: Oct 2008 Posts: 38 Thanks: 0 Thanked 0 Times in 0 Access If Error Then 0 I am running a query where I am dividing (fieldA/fieldB), there are instances where Field A and Field B have a zero value.

The time now is 07:49 AM. http://securityanalogies.com/ms-access/ms-access-error-3141.html However no matter what I try that query, or any of them I am getting the 'division by zero' error will not open in datasheet view. Hello, i have a problem with a division by zero fault in my report trough a query... Do you want to ignore it from the calculation of the average? Ms Access #error In Query

Your instructions worked. I wouldn't use IIf([text39]>0, I would use IIf([text39]<>0, Because what if you have a negative number? And it fails to open. navigate here You need the Is Null statement in that case.

tebule View Public Profile Find More Posts by tebule 07-20-2009, 02:51 PM #13 boblarson Former Moderator Join Date: Jan 2001 Location: Oregon, USA Posts: #num Error In Access Linked Table This forum is about taking the next step (or perhaps the next two steps) toward becoming a better Access programmer, and the AWF Forum Members will help you on your journey.To Backdoor account in passwd file Descriptive Statistics Custom theme selection Move just 1 match stick to make the 2 equations right How to professionally handle sexist remarks by a student?

Right off hand, I would guess spelling error or missing table reference.

I think I am pretty close though, but for some reason, my Nz() function isn't working properly. Not the answer you're looking for? Divide by 0 or null P: 4 kashman Hello, I am hoping this is an easy question for someone out there. Replace #error With 0 In Access It's quick & easy.

This will not work. You currently have 0 posts. Similar topics Divide two number Generate a random number then use that to divide the user input number An implementation where sizeof(short int) does not divide sizeof(int) Division by 7 without his comment is here Transforming data How can Data be property of Starfleet?

There are sometimes Zero's > in Ext Price Compare 1 and sometimes there are zero's in Ext Price Compare 2, > so for example: > Ext Price Compare 1 Ext Price Copyright © 2003-2016 TechOnTheNet.com. When I attempt to open that query is when I get the error.

© Copyright 2017 securityanalogies.com. All rights reserved.