IsError Function in Query

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I use the IsError function often in Excel but am unsure
about how to write the formula in Access. Can someone
show me how to write an "IIf(iserror(" statement in
Access? Here was my attempt that didn't work:

Weeks Supply: IIf(IsError([Table1]![Pipeline]/[Table1]!
[USW]),[Table1]![On Hand Qty],[Table1]![Pipeline]/[Table1]!
[USW])
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Since you're probably testing for a ZERO divider it may be easier to use
this:

Weeks Supply: IIf([Table1]![USW]=0,[Table1]![On Hand Qty],
[Table1]![Pipeline]/[Table1]![USW])

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQQfZy4echKqOuFEgEQJ0HACgh/KUFychnYCXx5JYr4aiPA+wM4gAoN3X
cJobcpMBIQYOj2IGAMUCown7
=PWIQ
-----END PGP SIGNATURE-----
 
Back
Top