Append Query is Sorting Incorrectly

[LOKIDOG]

I have an append query whose output is sorting on the first field. I want is in the original order = unsorted so that when I tranfer the data to excel it is in the order it was entered and easliy readible.

There are no sorts or indexes in any of the tables that the Query is based on.

Thanks.

 

[lupins46]

If you want a specifc sequence to your records you must use a sort key/index to do this. Otherwise , you can think of your table as a bucket of records and access will pick them in whatever order it fancies.

 

[dhookom]

I like to think of records in a table as school children on a playground. There is no predictable order until you blow a whistle and tell them to line-up (a query with an order by).

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]