Hi Chaim,

Requery didn't change anything for the "Order" clause, it's just worked for the "Where" clause, I've tried to use macro sub in building SQL View's, but still didn't work,nor with the REQUERY() clause also.

Regards,