SQL GROUP BY query dilemma/question

[Evadman]

er.... pretend I'm dumb and/or fairly new to this stuff

Then do what KentState suggested since you can modify the DB design.

I create a lookup table with all the of code values and right join to it.