Custom Sort based on a Sort Table

[Danick]

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]

If you are doing a left join then the sort is null. So make a field

Nz([sortfield],9999999)

 

[Danick]

Thanks - that worked perfectly.
And double thanks for responding so quickly!!