Hi all,
I am wondering if in a query I can get a value of a number as it refers to a value list?
The qry would be like
Code:
TransType: [TransTypeID] = 1;"Correction";2;"Deposit";3;"Open Balance";4;"Payment";5;"Purchase";6;"Receive Funds";7;"Transfer Funds";8;"Withdrawal"
TransTypeID is in query and is a number from my value list
The value list is 1;"Correction";2;"Deposit";3;"Open Balance";4;"Payment";5;"Purchase";6;"Receive Funds";7;"Transfer Funds";8;"Withdrawal"
Basically I am wondering if I can get Column(1) from the value list into a query somehow?
Thanks
Dave