Hi,

I'm trying to find out what the best way would be to find multiple records in a field. I'm not sure whether this is best done with a query or in vba.

I need to find every multiple record in the field and then append each multiple record,"including the other fields in the table," to a new, empty table.

Thanks for any and all help,

Dave

You need an append query. Set the conditions for the field values you want to move the records for in the query, and make sure you select all the fields in the originating table you want, and match them up with the fields in the receiving table.

Did that help?

mmcdonal

Thanks! I believe thats got it.

Well, I guess this didn't get exactly what I was needing. The only condition for the values is that they match another value in the field. I need to find a way to tell if two records in the same field are matches. I'm not sure how to use a query for this.

OK. Got this one figured out. I just created a new query and selected the duplicates query wizard. That found every record for me that appeared more than once.