I need to show on a report all client records with the most current date for a specific field.   For example: I want to display all the client records who contain a "P1" value in a specific field.  However, I don't want all "P1" values to display on the report for a client.  I just want the "P1" value with the most current date.

Thanks.  I figured that part out.    I found out I had more which I posted in another post.   I appreciate the help though!