Query for last order/invoice date & amount

[Ruth]

Hi,

I have all our projects and invoices in different tables
in my database. All the invoices are linked with the
project with a corresponding project number.

I need to draw a query that will give me the last invoice
date and invoice amount for each project.

Hope someone can help!!
Thanks,
Ruth