Re: Conditional Sorting on Report

This is untested but may work.

One new field: [Date for Sort]

[Date for Sort] = Formula Date field; if(Condition 1=true, [Pickup Date], Condition 2=true,"")

Sort Low to High By OutBound Inbound
Sort Low to high By [Date for Sort]
Sort High to low by [Pickup Date]

My thought is that if the Date for Sort is blank for all of condition two, they all 'tie' and then will be organized high to low by Pickup Date.

------------------------------
Michael Tamoush
------------------------------