whitestone
Usually Confused
- Local time
- Today, 05:55
- Joined
- Oct 29, 2002
- Messages
- 35
Here’s one for ya.
I have exported some duplicate records from a fundraising database (The Raisers Edge) into Access in order to use the application to help with identifying what record match exactly and therefore can be deleted.
I have one table with bio geographical info in and one with gifts linked up via a one-to-many.
The individuals in the bio table are all dupes and I need to find out whether their gifts match or not. If they do I can take their ID number and delete them if they don’t I need to merge them. There are 4396 bio records and 23986 gifts so I can’t be bothered to eyeball the data.
Any Ideas?
I have exported some duplicate records from a fundraising database (The Raisers Edge) into Access in order to use the application to help with identifying what record match exactly and therefore can be deleted.
I have one table with bio geographical info in and one with gifts linked up via a one-to-many.
The individuals in the bio table are all dupes and I need to find out whether their gifts match or not. If they do I can take their ID number and delete them if they don’t I need to merge them. There are 4396 bio records and 23986 gifts so I can’t be bothered to eyeball the data.
Any Ideas?
