Thanks for the reply. I'm on the right track, but lack the syntax ability. I have the following query:

SELECT Equipinv.mfg, Equipinv.model, Equipinv.sernum, Stumaint.clsdate,;
Stumaint.trhrs, Stumaint.drhrs, Stumaint.udrum, Stumaint.proller,;
Stumaint.froller, Stumaint.slpring, Stumaint.brushes, Stumaint.ctlhd,;
Stumaint.audhd;
FROM eng!equipinv INNER JOIN eng!stumaint ;
ON Equipinv.cmaster_index = Stumaint.cmaster_index;
WHERE stumaint.udrum = .T.
( I have omitted the ORDER BY )

I need to display only the MAX(DTOS(stumaint.clsdate)) for each equipinv.sernum.
The query above gets me very close, but displays multiple records for each
equipinv.sernum

Any help is greatly appreciated
Bruce Covey