Hey Richard,

I have a database that stores info for mothers with a yes/no field to indicate if the mother has a baby or not. The problem I am having is that, in this table I have duplicated values for mothers since the mother's ID is not the primary key. These duplicated values need to be deleted an they are one of the following two forms:
1- Repeated mother's ID but one record with yes for baby and other with no. I want the one with yes. (Note that it is okay to have no for other moms if their record is not repeated).

2- repeated record but with unique IDs and I want to deleted the one that ends with two zeros. For example C1666-12 and C1666-00 are repeated records and I only need the C1666-12.

Thanks in advanced for your help

---

Reply from Richard Rost:

This is going to be tricky. It's too in-depth for me to explain in great detail here. You're going to need some complex logic, a DCOUNT or two, a DELETE query, or a RECORDSET. If you can't figure it out, submit it via my TechHelp page and either I or Alex will do our best to help you with it.