Thanks - but I still haven't got it exactly

Si.....

I tried.....

SELECT MAX(BidValue) AS MaxBid, ItemID, BidderID
FROM Bid
WHERE BidTime =
(SELECT MIN(BidTime)
FROM Bid Bid2
WHERE ItemID = Bid.ItemID AND BidValue = Bid.BidValue)
GROUP BY ItemID, BidderID


This Returned.......

2200     2      ANS
900      1      MSM
200      2      MSM


I have no idea where that 200 has come from though - Help!

Ecniv

I couldn't get your SQL as written to work...

Did you mean this?

SELECT MAX(BidValue) AS MaxBid, ItemID, BidderID,
BidTime
FROM Bid
GROUP BY BidTime, ItemID, BidderID
ORDER BY BidTime DESC

If so this unfortunately returns every row in the table as the time is different for each row.