I'm trying to make a query that will take the highest bid amount for each lot number.
I did just a regular sort query that sorted by Lot_id(acsending) then Amount_bid(Decsending) and that was OK till I was told there's going to be around 1500 LOTS. Does anyone have any idea how to make a query that would fit this problem?
I think I'm one step closer to the answer. I'm trying to use a query just for two fields Lot_ID , Amount_bid and use the MAX statement for the Amount_bid field. Does anyone know how to make the MAX statement work in a query?