order by in macro

J

jomblo

hi all,

I made this option on form consist of two list.One is customer(value 1) and
second is Transaction(value is 2)
now i want it to be if user choose "customer", macro will order "customer"
field in the "Database" table in descending manner, whereby if "transaction"
chosen, then "transaction" field will be in descending order.
By the way both fields are in the same table which is "database" table.

please help me to make the macro working

TIA
jomblo
 
Top