Hi,

I have a database that lists each time stock items are purchased, who
they are purchased from and the date of that purchase.

I have a query that list those purchases, it's linked to the order
also to grab the purchase date.

The problem I have is that I've been asked to run a query that looks
up the last four purchase prices for each item, then get the highest
price of each to show as the base price for the database (I'll then
add their markup % to that).

I've successfully managed to list the last four in ascending order for
each individual item [using the Top Values facility in the query], but
I can only list all items or the tope four of ALL, not the tope four
of each, I need to get these last four of each before I consider
moving on to the top price of the last four!

Any ideas if this is possible? I've been around in circles so many
times I beginning to think perhaps I can only do it for individual
items, not the whole database!

Many thanks,

Jon