[Access VBA Central] Re: Tracking A Sum With Multiple Actions Under the Sum

[jre.phils]

Create a query, add a column and type this.
Action:IIf([Points]=10,"warning",IIf([Points]=16,"written notice" so on
and so forth.

Hope this will helps.
jre