Sort data in Access (1 Viewer)

Juolupuki

Registered User.
Local time
Today, 16:09
Joined
Jan 3, 2018
Messages
31
Hello,

Looking for solution or any suggestions, please. Having trouble to sort data in the why i need to.

In attached file "Unsorted" tab data need to be added in to MS Access table.
Second tab "Sorted" the why i need to be sorted.

The actual file is with over 600 rows, so manual to do is not really an option :(
 

Attachments

  • Ftest.xlsx
    31.8 KB · Views: 81

Gasman

Enthusiastic Amateur
Local time
Today, 16:09
Joined
Sep 21, 2011
Messages
14,044
Use a query to present the data in the order required.
 

isladogs

MVP / VIP
Local time
Today, 16:09
Joined
Jan 14, 2017
Messages
18,186
Access tables have no inherent sort order.
Queries are used to sort the data into an desired order
Therefore it doesn't really matter how you import the data - unsorted or sorted.
 

Juolupuki

Registered User.
Local time
Today, 16:09
Joined
Jan 3, 2018
Messages
31
Power Query in excel did the trick :) really good tool for sorting data.
 

isladogs

MVP / VIP
Local time
Today, 16:09
Joined
Jan 14, 2017
Messages
18,186
Glad you got it sorted.
Excel PowerQuery is indeed an excellent tool but really wasn't needed in this case. Access queries are perfect for sorting data
 

Juolupuki

Registered User.
Local time
Today, 16:09
Joined
Jan 3, 2018
Messages
31
Glad you got it sorted.
Excel PowerQuery is indeed an excellent tool but really wasn't needed in this case. Access queries are perfect for sorting data

Well for today was quicker to do Unpivot Columns in PowerQuery and sort that why :). In the future will try in Access.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 12:09
Joined
Feb 19, 2002
Messages
42,970
Sorting the data in the spreadsheet may seem like it solved the problem but it didn't. As Ridders already told you, in a relational database, tables and queries have no inherent order. Access tends to fool you because when you open a table in DS view, it looks like it is sorted in PK order. However, once you add more records and change existing records, you will see that behavior no longer can be relied on.

The ONLY way to ensure data is sorted as you need it to be is to use a query with an Order By clause. Period!
 

Users who are viewing this thread

Top Bottom