Expression issue in access query

[JH40]

Does anyone know if this is possible to do in a query (my expression is incorrect, but hopefully you can see what I'm trying to do):

IIf([Admit Risk]<=0.99,Sum([CountOfSumOfPriority]),"")

The Admit Risk column ranges from 0-35, so I'm trying to bucket them in multiple columns while summing the count from another column... Not sure how else to achieve this...

Thanks!

 

[JH40]

Good grief... Please disregard. I figured it out and my previous example was off the charts wrong. Hopefully it will make some of you chuckle!

 

[boblarson]

Hopefully it will make some of you chuckle!

...It did