“Most recent date” query in Access.

Hi,

I’m trying to solve the following problem in an Access “.mdb” database. I’m trying to find a way to query a date field of a table to obtain the most recent date, i.e. the most recent date from a range of dates on which invoices for a particular company were sent.

For example we have four invoices sent from Jan to end of July, however we want to catch the most recent one conditioned on today’s date (or the date of interest to us) and on the company.

Can you suggest a MS Jet SQL function or statement, or a combination of MS Jet SQL and a VBA function to solve the problem?

Thanks.

Boris