Question Duplicate enteries deletion in a table based on several criteria

pizzalover

New member
Joined
Oct 11, 2010
Messages
1
Programming Experience
Beginner
Dear Gurus,

I need your help for the following situation. I have a table called TblImportAgreements. All the records in this field is moved to TblMovetoStoredagreements and gets updated. Now I have an requirement that I have to modify the MS Access program so that all the records in the TblMovetoStoredagreements should have only unique records and the filter criteria for duplicate records should be appiled to the following colums in the table.

1. condition record no (only for Z00N and ZCPR)
2. condition type
3. customer number
4. material
5. discount group
6. net sales

I am also attaching the program wich moves from TblImportAgreements to TblMovetoStoredagreements with this and also the xls list. Please help me Gurus. I am very very beginner.

Kind regards,
Sony.
 

Attachments

  • ACCESS.txt
    10.7 KB · Views: 23
  • ACCESS_issue.pdf
    31.3 KB · Views: 25
Back
Top