How do you do an iferror function in access? or in this case if result = #div/0 then use a different formula
Novice
Windows Vista 
Access 2007
How do you do an iferror function in access? or in this case if result = #div/0 then use a different formula
Master of Nothing
Windows XP Access 2000
You can:
- use the ISERROR() function
- use an error handler routine and check for trappable errors. Div by zero is #11 (see trappable errors in Help)
- check for a NULL or zero value before dividing.
Maybe post your code so we can look at it and make suggestions to modify the formula??
Posting Permissions
Reply With Quote