General information
Category:
Coding, syntax & commands
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only