N nonrev1 Registered User. Local time , 21:03 Joined Jul 12, 2002 Messages 15 Aug 5, 2002 #1 My report is already producing a column [Lvl] that is displaying level 1, 2, and 3 accounts. I made it count all of them but what expression can I use to specify a count of only level 1 accounts? I've tried a hundred different ways
My report is already producing a column [Lvl] that is displaying level 1, 2, and 3 accounts. I made it count all of them but what expression can I use to specify a count of only level 1 accounts? I've tried a hundred different ways
P Pat Hartman Super Moderator Staff member Local time , 21:03 Joined Feb 19, 2002 Messages 45,265 Aug 5, 2002 #2 =Sum(IIf(Lvl = 1, 1,0))