Hi, when I run a simple append query, I get the following message below (See attached) I tried the solution in microsofts website that I have to set all text fields to AllowZeroLength to Yes, and i did that in both the table the data comes from, and the table the data is appended to. Still cant get it to work? Any other suggestions or is there somthign simple that im missing?

seems that 399 records are already in your table.
Are you sure you want to have double records in your table?
If so, add an autonumber field to your table to distinguish one from the other.

HTH

The other thing is, what are you using as a primary key?

JT-

we have had a small discussion on this - and if you explain to bob or Guus ,
they will be able to guide you in plainer english than i possible could

however i still think your d/base is slightly out of sorts

explain what you are trying to do and one of these guys may be able to help you with a simple bit of coding - rather than using append qry

Bob has a wealth of knowledge and if you explain to him- i am sure he will understand and communcate in better english than I possible could