Hi,<br>
<br>
This may be a silly question, but.........<br>
<br>
I know that Access 97 has a query to find duplicate records in a database. How would I go about having it delete those duplicates? One of my users has a Billing program that is built on dbf files using clipper. It's not y2k compliant, so I built her a access database by importing the dbf. She had to enter 380 duplicate records to get a report printed. I now want to delete them from my access table, but don't recall how.<br>
<br>
Thanks. <p>Phil<br><a href=mailto:Thorn@full-moon.com>Thorn@full-moon.com</a><br><a href= > </a><br>Most of us go through life not knowing what we want, but feeling damned sure that this isn't it.<br>
<br>
This may be a silly question, but.........<br>
<br>
I know that Access 97 has a query to find duplicate records in a database. How would I go about having it delete those duplicates? One of my users has a Billing program that is built on dbf files using clipper. It's not y2k compliant, so I built her a access database by importing the dbf. She had to enter 380 duplicate records to get a report printed. I now want to delete them from my access table, but don't recall how.<br>
<br>
Thanks. <p>Phil<br><a href=mailto:Thorn@full-moon.com>Thorn@full-moon.com</a><br><a href= > </a><br>Most of us go through life not knowing what we want, but feeling damned sure that this isn't it.<br>