append query

[patti]

i am trying to append from one table (NewItems) to another(Main), but get an
error saying it can't append 975 [of 4000] records due to key violations. The
target table (Main)has a composite primary key made of date and itemnumber.
All the items to be added have a new date that doesn't exist in Main. The
append query is left joined on NewItems ItemNumber, so that all records from
NewItems table should go into Main table.


What am i not seeing? Why are 975 items being rejected?

thanks.

 

[patti]

doh! i was using an expression to add , so i had to use a max query instead
of the Main table.

Hope this helps someone.