Creating a sorted table via query not consistent

[tmkraynak]

This should be really easy, but it is not producing the expected results. I want to create a sorted table from a query. The fields are selected and marked appropriately in the query. The preview is sorted correctly. But the resulting table is not sorted correctly. Running the same query multiple times, overwriting the table, SOMETIMES sorts it correctly, but it is not consistent. I am not in the table when the query runs. This is Access 2007. There are almost a million records in the file. what is the trick?

 

[PHV]

the resulting table is not sorted correctly
A table can't be sorted, but a query.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[tmkraynak]

Sorry, but that did not help.

A table can be sorted manually. A query has sort options. It does not make sense that a table cannot be sorted.

Any other ideas?

 

[traingamer]

Tables are not stored with any sort order. (PHV already said this).

What are you really hoping to accomplish?

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

 

[tmkraynak]

I need to have a sorted table in order to export the records in a specific order.

 

[PHV]

So, export a sorted query !

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886