Find most recent invoice and most recent funding for client

[Niyx]

Hello all

I'm sure the answer is on here somewhere but trying to find it and then getting it to work is a bit of a problem, so i resorted to posting.

I have 5 tables
Partnership Details, Invoices, Funding, Communication, Communication Types.

the field Partnership Name in the Partnership Details table has a one to many relationship with the partnership name on tables: Invoices, Funding and Comunication.

What I want to do is create a query that will show the most recent invoice (detirmined by date) and the most recent funding (detirmined by date) for each partnership.

I can do this using max if I only want the feilds Partnership name, invoice date and funding date. however I want to create a report that will show several feilds from partnership details and I want to show the invoice no. and amount as well as the date and also the amount and notes field for funding

Is anyone able to help?

Thanks
Niyx

 

[neileg]

Sometimes you need to run the Max query and then join this query back to the main table to retrieve the rest of the data. Sounds like you will need to do this here.

 

[Niyx]

Thanks Neileg

thats what i thought i needed to do but i can't seem to get it to work, maybe you could summarise how to do this?

 

[Niyx]

Sorry Please ignor previous post I realised it wasn't working as i was not linking the date field from the query to the date field in the main table