updating table after sort

  • Thread starter Thread starter Ben
  • Start date Start date
B

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


--
 
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
 
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
 
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 -
Click to expand...

you don't. Use a query instead.
 
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
 
Back
Top