Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Find only most recent entry

Edgar Aguilar

Recommended Posts

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.

Link to comment
Share on other sites

  • Create New...

Important Information

Terms of Use