Appending Overwriting, instead of appending

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can't figure this one out - an append query is overwriting the first record
in the table, instead of appending it to the end.

Please help - thank.
 
There's only one practical way for us to know: Show us the SQL. Open the
query in design view. Next go to View, SQL View and copy and past it here.
Information on primary keys and relationships would be a nice touch too. Also
any indexes.
 
Another thought: Are you sure that it's overwriting the first record in the
table OR it's just showing up first when you open the table? What is the
primary key field for the table? That's how you can tell.
 
Back
Top