How to sort data in a table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm importing 2 tables in my db from elsewhere. When the tables are imported
I'd like to sort on a field called date, however the data resorts itself on
import on another field.

In code, how can I sort a table's data based on a field?

TIA.
 
The order of data in a table is irrelevant. You cannot actually control it.

If the order of the data is important, create a query that sorts the data in
the appropriate way, and use the query wherever you would otherwise have
used the table.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import files into access 1
How to export table from outlook into ms access table? 0
Creating Checkbox Fields For Every Record 0
Save record order in main table 2
Export to Excel setting field types 14
Sort in VB using a ComboBox Column Other than the Bound Column 4
importing data from access to access 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Back
Top