two level make table query and sorting???

[tcek]

I am creating a table with a "make table" query. I want to query by customer
number than by date of order. I want the customer number to be ascending
while the date of order to be descending. I can make the query perform the
desired functions but when the table is made the sort order is not like it
should be. I want the table to look just like the query. Any advice would
help.

 

[KARL DEWEY]

I want the table to look just like the query. Any advice would help.
Don't try!
Access stores data records like a barrel of bricks, jumbled.

Use a query or report to do your sorting.