• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 661
  • Last Modified:

Sort access table using a macro

Is there a way to sort an access table using a macro?
0
morinia
Asked:
morinia
  • 2
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
No.  Create a query which contains the table, and in the Criteria row sort the resulting recordset by whatever column you wish, Ascending or Descending.

The sole purpose of a table is to hold data, and not to cosmetically display it in any fashion.  Leave that to queries, forms, and reports.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Thanks for the grade. Good luck with your project.  -Jim
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now