I have an Invoice table with 4 fields in which I need to pull that last invoice for a file_num.

SELECT Invoice.invoice, MAX(Invoice.date), Invoice.amount, Invoice.file_num FROM openclose!invoice GROUP BY Invoice.file_num

This gives me the Max date for a file_num but the invoice and amount don't match up with the date.

How can I get the Last invoice based on the invoice date?

Thanks in advance.

Derick Carlson