Append Query

[DBFIN]

I'm using a simple append query to append records to the end of an existing table. When I run the query, the records are automatically sorted within the table.

My intention is to append records so they remain at the end of the table without being automatically sorted. How can I do this.

 

[KeithG]

In a table there is no true first or last record, that would be a violation of the relational model. Why do the records need to be at the "end".

 

[Ziggy1]

this is MS Access I assume, what version?


and you don't have any sorting set in the query? I can't see it sorting your table if nothing is set in the query to sort?

 

[jdraw]

I'm using a simple append query to append records to the end of an existing table. When I run the query, the records are automatically sorted within the table.

My intention is to append records so they remain at the end of the table without being automatically sorted. How can I do this.

I'm guessing that you have some default order on the table.

 

[DBFIN]

We append records in weekly batchs. If the user appends records with data errors, having the records at the end of the table allows for easy deletion of the records. I agree with jdraws guess that there's a default order on the table. I don't know how to remove the default.

 

[Mike375]

What about adding a field to the table with a default of Date() and don't include that field in the Append.

 

[DBFIN]

Mike 375,

This sounds like a great solution, I'll try this.

 

[DBFIN]

Problem solved. Thank you very much.

 

[Mike375]

When I was reading your post I was just checking some records where I have Date() for a default and for the same reason or least same principle as your post