Append query duplicate

[abanob]

Hello everybody I need your help for an query .
I have a database its contain 2 tables and append quires there is primary key which does not accept duplicated values in this field
I open date base from another pc when i open append query its duplicate the value one more time

 

[arnelgp]

try the New append query.

 

[abanob]

try the New append query.

its working
thank you very much

 

[abanob]

But i have problem because this fields repetition every month and i need to append every month for one time
the field (Y) is a primary key i need to append every month from one pc only

 

[arnelgp]

here again i added Month() and Year() criteria on the query.

 

[abanob]

Sorry
I will show you something on my database have query its repeat every day from the date in the filed of Sup_Date
And when i and others people open the database every day and the append query duplicated the same values
You can open qryReminder