Expressions in queries that have an #error message come up in rec

[M Wiseman]

I have the expression in a query,
% Change WOW Units: ([Last Week POS Qty]-[Current Week POS Qty])/[Current
Week POS Qty]
I keep getting an error message in records. I believe it is because some
records have 0 as the qty. How do I have it not recognize the value as a
zero and thus not get the #error message?

 

[kingston via AccessMonster.com]

IIF([Current]>0,(([Last]-[Current])/[Current]),0)
Make sure you enclose the subtraction in parentheses. Otherwise it'll always
result in [Last]-1 if [Current]<>0.

I have the expression in a query,
% Change WOW Units: ([Last Week POS Qty]-[Current Week POS Qty])/[Current
Week POS Qty]
I keep getting an error message in records. I believe it is because some
records have 0 as the qty. How do I have it not recognize the value as a
zero and thus not get the #error message?