Im thinking a query
SELECT TOP 2 MyDate FROM MyTable ORDER BY MyDate DESC;

try it and tell us what happened

Thanks for your reply, I need the date for each item?

Juan's query will return the last two records in your order table, sorted by date. You might need to add other criteria as well, such as the product ID. See Top X.

Looks like I didn't clarify enough.
I have a query that returns the sum of the quantity of multiple items and I want to have a column on there which returns the date it was sold last time prior to the last how do I make the query that show it so then I can make a relationship to my existing query.
I hope that clarifies enough..

I've actually got a video on this topic coming out soon. Stay tuned.