Safari
Member
- Local time
- Today, 16:46
- Joined
- Jun 14, 2021
- Messages
- 95
Hi All ,
I need your help
My problem is that the data is repeated every time the query runs
I want to run the append query without duplicate data and append only the new records, not the old and new ones.
Attached is the database for help and modification
Query name: Appendfrom
Table to be append : StoreTransaction
append from the table: Headstoretransfer + StoreTransactionTRANSFAER They have a one-to-many relationship
Appending transno field with the SerialTransfaerfrom . field
If there is no transno number, it is appended (NOT IN function)
And in the case of a transno number, it is not appended.
Thanks in advance ..
I need your help
My problem is that the data is repeated every time the query runs
I want to run the append query without duplicate data and append only the new records, not the old and new ones.
Attached is the database for help and modification
Query name: Appendfrom
Table to be append : StoreTransaction
append from the table: Headstoretransfer + StoreTransactionTRANSFAER They have a one-to-many relationship
Appending transno field with the SerialTransfaerfrom . field
If there is no transno number, it is appended (NOT IN function)
And in the case of a transno number, it is not appended.
Thanks in advance ..