General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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,
>
>Do you realize that you are losing data with what you are doing? The dates and the separate transactions will be lost forever when you combine these records into one. You might be best served to leave them as multiple records and use SELECT to bring the records you want together when you need them together.
Sunshine,
Jim's point is a good one. What I believe that you want is to create a people table based on your duplicate query. Once built, you can assign (or have auto-assigned) primary keys for the people. Then, after adding a foreign key column to the existing table, you can link the transactions with the people.
HTH.
Doug
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only