How to have crosstab query recognize most recent of multiple dates?

[WebFaktor]

I'm running a crosstab query against company training records. The query is structured with each employee (name, ID, Title, Location & etc.) being granted a row, and the column headers representing training events. If an employee has completed a training event the result will be a date field (date training began)appearing accross from his/her name and beneath the training event to which it relates. If employee did not take training event the cell accross from their name and beneath the training event will appear blank.

Here's the problem: If an employee participated in a training event twice what the query does is adds the 2 date fields together. For example: if an employee took the same training event on both Jan 5,2002 and Jan7,2002 the resulting completion date will appear as Jan12'4004. Is there any way for me to direct query to recognize only most recent completion date?

Thanks in advance,

Michael/WebFaktor

 

[WebFaktor]

No need to reply, I figured it out by searching through existing questions within the forum.

On the date field within the crosstab query I changed the format from Sum to Max. Doing this, presented me with the most recent date.

Thanks anyway,

Michael/WebFaktor