Criteria for query to pull the hightest number

[jagnval]

I am still working on an auction database, I have a table that collects the following: (Item/Ending Bid date/Current Bid Amount/Ending Bid amount/ Bid time/ And bidder/) and i need to create a query that pulls the highest "ending Bid Amount" (or winning bid),or the latest date for each item ,so i can send an email with the winning bidders. , how to I single out the last bid for each item. Please help thank you.

 

[jrbarnett]

SQL Code similar to the following will give you the latest bid for each item:

select Item, max ([Ending bid amount])
From yourtable
Group by Item

For the latest bid date, use the [Ending bid date] in the max field instead.

John

 

[SeeThru]

Also, have a look at Dmax()

SeeThru
Synergy Connections Ltd - Uk Telemarketing and Telesales Services and
Synergy Mobile Solutions - UK Mobile phones, land lines and call packages