Sorting in access queries

[reggied]

I have a query that only has 4 fields: SalesOrder, SalesOrderID, FabSO, and PODate. When it is sorted by PODate it sorts as shown below:

SalesOrder SalesOrderID FabSO PODate SDR049 qryUniqueSOFromtblTempFabReq [td] 3443​

FAB022
SDR050	FAB022
SDR051	FAB022

​

[td]

5/13/2025​

[/td]​

[td]

3444​

[/td]​

[td]

5/13/2025​

[/td]​

[td]

3447​

[/td]​

[td]

5/15/2025​

[/td]​

[/td]

If I create a 2nd query that only pulls in the SalesOrder and PODate fields and sort by PODate I get the below result:

SalesOrder PODate SDR050 Query1 [td] 5/13/2025​ SDR049 ​ [td] 5/13/2025​

SDR051

​

[td]

5/15/2025​

[/td]​

[/td]

[/td]

Any guesses as to why it switched the order?
Only asking because I am using Allen Browne's ConcatRelated function and it is sorting the list as shown in Query1 even though it is sorted by PODate. I thought there might be a time component that's causing a secondary sort but:

SalesOrder PODate Time SDR050 Query1 [td] 5/13/2025​

SDR049

SDR051

​

[td]

12:00:00 AM​

[/td]​

[td]

5/13/2025​

[/td]​

[td]

12:00:00 AM​

[/td]​

[td]

5/15/2025​

[/td]​

[td]

12:00:00 AM​

[/td]​

[/td]

​

 

[reggied]

Trying to figure out how t delete this post because the tables are not viewing correctly. Also, I solved the issue by adding a secondary sort after the PODate sort.

 

[plog]

When you have ties there's no predicting how its going to sort.

If you want to ensure the same sorting you should add a unique field in addition to the date one.

 

[MajP]

To have tables post correctly see discussion. This used to work.

Problem Posting a table

I really liked the feature that allowed you to post a table. I would simply copy an Access table and paste. Was super helpful in describing problems/solutions and worked great. I can no longer get it to work. It looks good in edit mode but in the posted mode it looks like this with some of...

www.access-programmers.co.uk

You can always edit or delete a prior post. See buttons at the bottom of the post.