Re: import access query to excel causes order of records to change
- From: John Nurick <j.mapSoN.nurick@xxxxxxxxxxxxxx>
- Date: Sun, 24 Apr 2005 17:14:02 +0100
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.
On Fri, 22 Apr 2005 14:04:02 -0700, "NN" <NN@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
>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.
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
.
- References:
- Prev by Date: Export to Excel 2000/2003 from Access 97
- Next by Date: Re: Export to Excel 2000/2003 from Access 97
- Previous by thread: import access query to excel causes order of records to change
- Next by thread: importing data with ODBC Data
- Index(es):
Relevant Pages
|
