Access append query problem

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 ?

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


"bartheyvaert" wrote in message
lkaboutsoftware.com...
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 ?

On Wed, 20 Apr 2005 08:09:19 -0400, "bartheyvaert"
wrote:

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]