Hey all,
I'm at work on Saturday < sigh > and I have the following query that seems to produce the correct results:

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,2

But 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!!