How stop Append from sorting records?

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

I have an append query that does a left join on 2 tables. The query orders
the records according to the order in which they are stored in the left table
(the 2 tables are really links to a dbase db (left) and an external ACCESS db
(right)).

When I have the query append to an empty table (just has the fields defined,
Order By On Load = No, Order By = No, no primary key, all fields are text),
the records are appended in sorted order using the first field (which is not
the join field FYI).

How can I stop the sorting during the query append operation so that the
records are stored in the order the query displays - which is the order of
the records in the dbase file?

With Regards-
Sam
 
Thanks for your response-
Why is it important to you that the
records in the table be in some specific order?
Click to expand...

This db is part of a data set that makes up an ESRI shape file. The db
records need to stay in the same order so that they remain in synch with the
other files.
 
Sam,

In Access the BEST way to control the order of the records is via a query.
You can set the Order By in the table Properties window. I've never done
that and then appended data but it should retain the order.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
Back
Top