Multiple Records with same ID to one record

[MTSPEER]

Hello,

I have a table that has an ID field with multiple fields. I have multiple queries that validates data from that table and appends the invalid data onto an Error_Sheet table. And every single validation query I run the ID from the main table appends to the Error_Sheet table. Well if there are multiple errors within the same record. It makes multiple records on the Error_Sheet table with the same ID. I want to have it so all of the errors goes to one record with that ID.Every query validates a different field.

Your help would be much appreciated. Thanks.

[June7]

How do queries validate data and append invalid data to another table? There is VBA code running this process?