Appending Overwriting, instead of appending

A

Anne

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.
 
J

Jerry Whittle

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.
 
J

Jerry Whittle

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.
 
Top