I already have a field in my table that specifies the
date when the price was set .
the problem is after selcting my records via company number and product number I have a few records in my recordset (each with a differnt date of when I set the price for the perticular company) I want to get the record with the latest date with out knowing what the latest
is.
I am trying to do it in the sql statment.
Is there a way?
Thanks.
Dan.