I need to display the most recent payment amount and date from a case number. For example, case number #1999 can have eight rows of different payment amounts and dates. I need to display only the most recent one from these multi-valved fields. SQL resides in an ASP script on MS SQL Server 7.0. Thanks.