import access query to excel causes order of records to change

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I wish to import a list of invoices into excel and keep the order of invoices
intact. Some invoices begin with letters and they are all of varying
lengths.
 
The only way of controlling the order in which a query returns records
is to sort it on one or more fields. These can be actual fields in the
underlying table, or calculated fields whose only purpose is to return
values that sort into the order you want.

If table of invoices includes dates, would it suffice to sort them by
date? Otherwise, you'll need to create a calculated field. If you want
help with that, post back here giving examples of the data that needs to
be sorted and how it needs to be sorted.
 
Back
Top