Access append query problem

[bartheyvaert]

I'm having a problem using a microsoft access append query : when appending
the records to the destination table, the records are not sorted in the
table the way I want them to be.

It's like access is ignoring the sorting criteria in the append query ?

 

[JohnFol]

There is no such concept of data stored in a "sorted" order within ANY
database. If you want to see the records in a particular order you need a
Query with an Order By clause

 

[John Vinson]

I'm having a problem using a microsoft access append query : when appending
the records to the destination table, the records are not sorted in the
table the way I want them to be.

It's like access is ignoring the sorting criteria in the append query ?

Yep. That's how tables work: they're unordered "heaps" of data.

If you want to see data in a particular order, you CANNOT rely on the
table to sort it. Instead, be sure that you have a field or fields
within the table which define the desired order, and use a Query to
sort.

John W. Vinson[MVP]