Need more info, Mike. Are these two different tables? Is there a relationship in the data environment?

Sounds like something like:

SELECT MAX(saledate) AS lastsale FROM sales WHERE sale.vendorID = vendors.vendorID



>If I want to populate a text box on a form that displays vendor information with the date of the last sale, how would I go about doing that? I can easily display the first occurance of the vendor id number in the sales table, but having difficulites getting at the most recent sale.
>
>Mike