Hi,
This is incredibly annoying.
This no longer is working. This morning when I replied, the query you provided at least DID SOMETHING. Now it does not.
This does absolutely nothing:
Code:
sql = "SELECT Q_Main.QuoteID, Q_Main.Version, Q_Main.Fruit, Q_Main.Age FROM Q_Main WHERE (((Q_Main.QuoteID) In (SELECT TOP 1 TEMP.QuoteID FROM Q_Main AS TEMP WHERE TEMP.QuoteID=Q_Main.QuoteID ORDER BY TEMP.version DESC))) ORDER BY Q_Main.QuoteID;"
I can't get any solution here that returns any results.
Can you please provide a working copy of my DB with your fixes?
Thank you