append query without duplicate record

[smahdih]

Dorod (means Hi)



i create a append query but every time i run this query records duplicate,

i have a form and a button in form, user type required records in form and then press button, in event click button i have
docmd.openquer "append query"

but every time in table create duplicate records

how fix it?

[orange]

Do you have a Primary Key on your Table?
Show us the table design, and the query SQL

[smahdih]

Do you have a Primary Key on your Table?
Show us the table design, and the query SQL

Yes, i have a primary key,

below code is query sql

INSERT INTO tblKhahSend ( OrderCode, RecieveDate, LeadTime, OrderStatus, Description, KanbanName, QuaOfKanban, OrderDate, SendDate )
SELECT tblKamRecieve.OrderCode, tblKamRecieve.RecieveDate, tblKamRecieve.LeadTime, tblKamRecieve.OrderStatus, tblKamRecieve.Description, tblKamRecieve.KanbanName, tblKamRecieve.QuaOfKanban, tblKamRecieve.OrderDate, tblKamRecieve.SendDate
FROM tblKamRecieve;

[orange]

INSERT INTO tblKhahSend
( OrderCode, RecieveDate, LeadTime, OrderStatus, Description, KanbanName, QuaOfKanban, OrderDate, SendDate )
SELECT
OrderCode, RecieveDate, LeadTime, OrderStatus, Description, KanbanName, QuaOfKanban, OrderDate, SendDate
FROM tblKamRecieve;

Your primary key is IdSend which is autonumber. Why do you say you get duplicates?

Why are your Date field of Text datatype, why not Date/Time datatype?

[smahdih]

Your primary key is IdSend which is autonumber. Why do you say you get duplicates?

Why are your Date field of Text datatype, why not Date/Time datatype?

just different idSend, other fields are similar.

i create a find unmatched query and then append it to tblTable1.

yes , of course , must be date/time type.

i do it and worked.

sepasgozar (tnx alot)

[smahdih]

i have a problem, when update a record in main table and run append query,
tbltable1 not update,
how fix it?