Custom Sort based on a Sort Table (1 Viewer)

Danick

Registered User.
Local time
Today, 14:58
Joined
Sep 23, 2008
Messages
351
I have a report that sorts the data based on a linked sort table.
But there are records that are not linked to the sort table.
Is there a way to sort those entries that are not in the sort table list to the bottom?
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 14:58
Joined
May 21, 2018
Messages
8,463
If you are doing a left join then the sort is null. So make a field

Nz([sortfield],9999999)
 

Danick

Registered User.
Local time
Today, 14:58
Joined
Sep 23, 2008
Messages
351
Thanks - that worked perfectly.
And double thanks for responding so quickly!!
 

Users who are viewing this thread

Top Bottom