I want to open a recordset based on the latest date of a few records.
So far I have:
set rst = DB.OpenRecordset("select *from [prices] where [Company number]=" & company_number & " AND [product number] =" & product_num ).
I'm not sure how to fit in the clause that specifies the latest date.
Thanks for your time.
Danny.