sorting

5 Topics

Sort in Query not Displaying
I have no clue how to word this. Basically, in a form I have a field called Members. This field is a drop down menu that lists all of the Members for a meeting via check boxes. I can then tick the checkboxes for the people who attended the meeting, click 'ok', and then when when I run the report, their names will appear. I don't need this information saved; just to display on the report so I can print it. Here's my problem. Not all of the members can vote, so I want the members who can vote listed first, and the rest of the members listed next. I've put in my custom sort formula in the Members query. When I open my Members dropdown box, they are listed exactly the way I want. However, as soon as I tick on the names and then click 'ok,' it's displayed in order of the primary key. When I run the report, the names are still sorted by the primary key. I've gone to every query and table I can find to create my custom sort, but it keeps defaulting to sorting by the primary key. It's driving me INSANE. Any idea why it's doing this? I've dug through google and haven't had luck finding an answer that works. Thanks in advance!
Solved
nicoleethier
Jul 09, 2025 Place Access
676Views
0likes
16Comments
Pivot Table not sorting
I added some data to a pivot table and was trying to sort it from A-Z, the data sorts but for some reason the new data sorts beneath the original data and therefore won't mix so I can't group it appropriately. Any advice would help.
FRobinson25
Oct 08, 2019 Place Excel
2KViews
0likes
1Comment
SPECIAL NUMBER SORTING
I am trying to sort a spreadsheet with special numbers. it puts 129.01.00A ahead of 13.01.00, 71.01.00 etc. I want it to sort by the number ahead of the first decimal, then by the second, etc. e.g. 13.01.00 then 71.01.00 then 129.01.00A I have tried formatting by number, by general, by accounting. Any help appreciated.
JRoy-55
Aug 26, 2019 Place Excel
1.2KViews
0likes
1Comment
Multiple files in different column order
Hello, I have over 1000 CSV files with different column order. For example, file1: name, phone, date, question file2: phone, date, question, name file3: question, name, phone, date how can I reorder the columns of them in a quick way?
PPDD129056
May 26, 2019 Place Excel
1.8KViews
0likes
2Comments
Sorting data - by reference
Hi I have data set like this; Date Reference 28/11/2017 119737 28/01/2018 119737 28/02/2018 119737 28/03/2018 119737 07/09/2017 119787 07/10/2017 119787 07/11/2017 119787 07/12/2017 119787 07/01/2018 119787 07/02/2018 119787 07/03/2018 119787 28/09/2017 119807 28/11/2017 119807 28/09/2017 119839 28/10/2017 119839 28/11/2017 119839 28/12/2017 119839 28/01/2018 119839 28/02/2018 119839 28/03/2018 119839 01/10/2017 119931 01/11/2017 119931 01/01/2018 119931 01/02/2018 119931 I need to split the references /dates to different CSV files as one file cant have duplicate references. Im currently filtering and numbering, then will move all 1's, all 2's etc. Is there a quicker way to do this? Thanks :)
LauraDaisy
May 01, 2018 Place Excel
2.7KViews
0likes
8Comments