-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
sort tables by date Access 365
- Thread starter MetLife
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,265
- Office Version
- 365
- Platform
- Windows
You don't sort records in tables - you sort them in queries!
Order really has no meaning in tables. Someone once used a metaphor that a table in Access is like a "bag of marbles". The records are unrelated to each other.
You use queries to perform things like sorting, filtering, doing calculations, etc.
Order really has no meaning in tables. Someone once used a metaphor that a table in Access is like a "bag of marbles". The records are unrelated to each other.
You use queries to perform things like sorting, filtering, doing calculations, etc.
Upvote
0
No I mean I made table xyz at time 2/3/2024 etc...
So I want to sort when the tables were created. When you open Access the tables are listed in alphabetical order. I want to change the order.
Upvote
0
welshgasman
Well-known Member
- Joined
- May 25, 2013
- Messages
- 1,329
- Office Version
- 2007
- Platform
- Windows
Rename them with a date prefix?
Upvote
0
try this tool (a date instead of Object Type). However, such a request makes me think you have a bunch of similar tables and you want to sort them by date, which smells like you have a db that is not properly normalized.
Upvote
0
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,265
- Office Version
- 365
- Platform
- Windows
As welshman suggested, I would lean towards renaming the tables with a prefix of their date in "yyyymmdd" format. Then they will be in order when sorted alphabetically.
However, Micron also makes a good point - if you have a bunch of tables that are all structured the same, but just with different dates, it sounds like you have a un-normalized database, which is going to make it a pain to work with. In a normalized database, you typically do not have multiple similar tables with the same structure. Your database structure should not change all that often, just the table in it, so you do not need to constantly create new queries and reports.
In a normalized structure, you would probably only have one table that stores all this data, and the data would have a field for the creation date, so you can easily differentiate all the data. So you would import all your daily data into this one table.
However, Micron also makes a good point - if you have a bunch of tables that are all structured the same, but just with different dates, it sounds like you have a un-normalized database, which is going to make it a pain to work with. In a normalized database, you typically do not have multiple similar tables with the same structure. Your database structure should not change all that often, just the table in it, so you do not need to constantly create new queries and reports.
In a normalized structure, you would probably only have one table that stores all this data, and the data would have a field for the creation date, so you can easily differentiate all the data. So you would import all your daily data into this one table.
Upvote
0
Similar threads
