Hi Andy,

To do a group by Date, in the Pivot Table List, Pull the Date off of the Report Filter and put it in a Row Labels box above the student name.

Lets make data entry a lot easier. I'd make the student column on the Data tab a Validatiaon Lookup. Then when you type a student it will autofill in his/her name after a few letters. I'd also fill in all the Dates after entering in the codes. There are some other tricks for entering data but see if Validation helps first. If a student has 5 infractions enter him once and then click Ctrl C to copy his name in the clipboard and then select the 4 blank cells below him and press ctrl-v to paste him 7 times. There are other ways but try this first.