Find last price paid...

I have a need to lookup all products purchased by a particular customer and the last price paid. I am running Access 2002 database. I can easily build a query and report to show all products and all purchases, but I am drawing a blank on how to pull just the last purchase for all products. Any ideas anyone?
TA

Tell us a bit about how you have you db structured.

Do you have a date field in your "purchase table?"

Create a field in your purchase table call the whenpurchased and make it a date/time field, in the default value enter now() in the format set General Date.

What will happen is when a new record is created this field will be filled with the date and time to the second. In the query sort the records using the "whenpurchased" as decending and the last purchase will appear at the top.

Add the customers name and any other fields you want and bingo it will work. You could create a form that will give you this information, just use a combo box to look up the customer name and the you would be able to see say there last 10 transactions.

Hope this helps,


Regards,