Thread: [SOLVED] Error on IIF
View Single Post
Old 08-12-2019, 08:56 AM   #23
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,584
Thanks: 68
Thanked 2,755 Times in 2,639 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Error on IIF

if you are using Grouped by query, use this as "Expression"
Code:
PercentageFail: Sum(IIf([successful]=0,1,0))/Sum(1)*100

PercentageSuccess: Sum(IIf([successful],1,0))/Sum(1)*100
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote