I'm using Totals: Sum(IIf([ShowTime1st]>0,1,0)+IIf([ShowTime2nd]>0,1,0)+IIf([ShowTime3rd]>0,1,0)+IIf([ShowTime4th]>0,1,0)+IIf([ShowTime5th]>0,1,0)) to sum totals in a query and it works great, however I have been told that if the school is SchoolType 3 then it gets a half value (.5) for each ShowTime
I can't figure out how to sum those that aren't 3 with those with 3. So if a few of the schools are type 3 then they get added to the total but as .5