SELECT Audit98.Audit, Audit98.IPN, Audit98.EndDate, ; MAX(PrvBeds.EffDateB), PrvBeds.CertifBeds, PrvBeds.MorBeds ; FROM Audit98, PrvBeds ; INTO CURSOR Latest_Beds ; WHERE Audit98.ipn = PrvBeds.ipn ; and audit98.enddate >= PrvBeds.EffDateB ; GROUP BY 1,2But my coworker seems to think use MAX() in a query in this manner is not correct due to some foxpro glitch. This glitch is new to me, but we're under the gun and I need quick confirmation that this query should be fine. Can anybody confirm or explain a glitch with using MAX() in this manner? TIA!!