Mark,

Instead of this:

>select field1 from file1 order by field3;

try:

select field1,field3 from file1 order by field3;

Also, if using Access Linked Tables, a whole new syntax is used for Access
Linked Tables, that resembles DBNAME_DSET.Item, as opposed to just Item.  You
may wish to use MSQuery or MSQry32 against the Access database with the Linked
tables, and use the Query Builder to put the query together for you.

Regards,
Joe