Moderator note: Buggie recently posted this question and it was, well, buggy! I'm reposting it here for him with a clean format. Thanks Buggie! I'm relatively new with Crystal Reports and I would woudl appreciate any help with a formula. I am using CR 10 and my data is stored in several tables. What I want is a report of individual services per client with diagnosis, location code and amount of service. For example: This is what it looks like. Client ID Date of Ser Ser Cd Amount Diag Loc Cd 474747 08/01/09 90862 56.00 311 CS40 474747 08/01/09 90862 56.00 312.58 CS40 474747 08/01/09 90862 56.00 313.13 CS40 474747 08/02/09 90808 47.50 311 CS40 474747 08/02/09 90808 47.50 312.58 CS40 474747 08/02/09 90808 47.50 313.13 CS40 474747 08/10/09 90806 35.40 311 CS40 474747 08/10/09 90806 35.40 312.58 CS40 474747 08/10/09 90806 35.40 313.13 CS40 474747 08/30/09 97535 45.00 311 CS40 474747 08/30/09 97535 45.00 312.58 CS40 474747 08/30/09 975.5 45.00 313.13 CS40 My problem is for each diagnosis update I get individual services per diagnosis update. It's overstating the amounts per service per client. Can anyone help with a formula to state that I only want the most recent diagnosis information. I have already used the Select Distrinct Records in Crystal but it didn't help much. This is what I want it to look like. Client ID Dat of Ser Service Cd Amount Diag Loc Cd 474747 08/01/09 90862 56.00 311 CS40 474747 08/02/09 90808 47.50 311 CS40 474747 08/10/09 90806 35.40 311 CS40 474747 08/10/09 97535 45.00 311 CS40 Any help would be appreciated. Thanks

Software/Hardware used:
Crystal Reports 10