View Single Post
  #1  
Old May 27th, 2010, 11:03 PM posted to microsoft.public.access.queries
tcek
external usenet poster
 
Posts: 48
Default two level make table query and sorting???

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.