I had a conversation with a friend that told me when deleting a record from an Access db that DELETE DISTINCTROW was not necessary. The example used was that you select a group of records that meet your criteria in a certain field and then you can simply state DELETE FROM TABLE1. Is this valid? There has got to be more than this doesn't there? I understand the logic behind it but I'm not sure it's as simple as DELETE FROM TABLE1.<BR>Comments?