Find only most recent entry

[Edgar Aguilar]

Hello All.

 

I have two tables: CLIENT and BILLING. They are related through an CLIENT ID.

 

The CLIENT table contains children who are enrolled in our program. The BILLING table contains the following fields: Invoice Date, Invoice Amount, and Funding Source.

 

I'm trying to find information based on the FUNDING SOURCE field for the most current INVOICE DATE (i.e. Fund 1, Fund 2). The INVOICE DATE varies from client to client.

 

Is there anyway to identify the record containing the most recent invoice date and then pull data from other fields from the same record?

 

Thank you for any advice you can provide.