Getting last date in a crosstab

[Dugantrain]

What I have is several kits with parts in them that are out in the field. Not all kits are used every single day, but the days that they are used is captured by the date. What I need is a crosstab which lists all the kits in one column, the items as the row, and the number of parts where column and row intersect. Easy enough, but the catch is that I want another column to see the most recent activity; i.e. the most recent date. I can't use the Last function as archived information can be entered at any time and the input isn't necessarily chronological. Is there a way that I can capture the most recent date for these kits?