updating table after sort

[Ben]

Hi all,

I have a table. I ran a query to sort the records in the table. After
that, I set a recordset to the query result. But I need to update the table
in the new sort order.

How can I set the order in the recordset back to the table in the sorted
format?

Thanks,

Ben


--

 

[Jeff Boyce]

Ben

You may be confusing "where" and "how" the data is stored with how the data
is displayed. Access tables are "buckets o' data" and do NOT have any
readily-discernable order. That's what you use queries and sorting for.

If you query returns the sorted dataset, why not use that?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Ben]

Jeff,

I guess the question is how can I make the sort stick in the Access
table, so that when I open it the next time, it is already sorted by the
particular field I choose.

Thanks,

Ben

 

[pietlinden]

Jeff,

   I guess the question is how can I make the sort stick in the Access
table, so that when I open it the next time, it is already sorted by the
particular field I choose.  

Thanks,

Ben

--








- Show quoted text -

you don't. Use a query instead.

 

[Jeff Boyce]

What Piet L. said -- use a query. Don't try to force the Access table to
perform unnatural acts.

Regards

Jeff Boyce
Microsoft Office/Access MVP