Toad World® Forums

Where Condition-Form-Constant=multiple selections=TDA-Newbie


#1

Just downloaded trial for TDA
Trying to select several constants from drop down.
Where Condition = Tran_code =constant=BA,BG,DP,IE,WD.
Is there a way to select multiple values.

Once I figure out how to select thoes values need to
preforma a math computation FOR COLUMN TRAN_AMOUNT
ADDING BA+BG+DP+IE AND MINUS WD=TOTAL

SQL SERVER 2005 database
Thanks
FOR ANY IDEAS

Message was edited by: mwwilliams_640

Message was edited by: mwwilliams_640


#2

For the where condition, change the operator to ‘IN’ and separate your values by commas. In the next version you will get a list of values with check boxes and it will automatically added the selected values. (This is in TDA 2.6)

For the second item use a calculated field. See the help file for details.

Debbie


#3

Thank You