Do more with
SELECT Person,
Sum(IIf([Project] <> "Beneleave", Nz([Month1], 0), 0) / (Sum(Nz([Month1], 0)) + 0.00000000001) AS Jan,
Sum(IIf([Project] <> "Beneleave", Nz([Month2], 0), 0) / (Sum(Nz([Month2], 0)) + 0.00000000001) AS Feb,
Sum(IIf([Project] <> "Beneleave", Nz([Month3], 0), 0) / (Sum(Nz([Month3], 0)) + 0.00000000001) AS Mar,
you get the idea
Sum(IIf([Project] <> "Beneleave", Nz([Month12], 0), 0) / (Sum(Nz([Month12], 0)) + 0.00000000001) AS Dec,
FROM SomeTable
GROUP BY Person
ORDER BY Person
Premium Content
You need an Expert Office subscription to comment.Start Free Trial