Thanks Vlad / Hilmar,

I found a work around though. I adjusted the values in the LotSort column created using the SQL Select. Since the Zip4 is a number (although a character type field) and only 4 characters, for those with a "D" LotOrder I did a 1000-Val(Zip4) or 1000-Val(DP). This lets me do an ascending sort and still come out with the desired result.

"Select *, ' ' As Stream, ;
PadL(IIf(Left(Cart,1) = 'B', IIf(LotOrder = 'D',Transform(1000-Val(Zip4)), Zip4), IIf(LotOrder = 'D',Transform(1000-Val(DP)), DP)), 4, '0') As LotSort From MasterFile

Thanks for all your help guys.

Aloha,

James