If I had a primary field my life would be so much easier! To find duplicate records, I need to compare the dob,last_name, and first_name. Then I can combine the cost. Also, I'm going to need to check the license they are buying. Example, if first they bought a fishing license and second record they bought a hunting license, I need to make the license = to hunting and fishing along with sum(cost).

Any ideas?

Sunshine

p.s. Thanks for your response!