hi all,
i have a problem displaying my results.
i have created a table with 3 fields: "customername","dealers" and "ISP"
-customername will store names of customer( obviously )
- ISP and dealers data type are just yes/no
lets say i have created a OR expression between "dealers" and "ISP". when i select "dealers" and "ISP".
customername dealers ISP
------------ ------- ---
bob yes yes
cat yes
dog yes
but all i want is BOB's name to appear.
But lets say i use AND expression instead and select the same 2 fields: dealers and ISP
customername dealers ISP
------------ ------- ---
bob yes yes
that will satify my criteria but lets say i only select "dealers", "bob" name will not appear but instead only
"dog" will appear.
thats not i expect, i expect "dog" and "Bob" to appear.
how do i solve this problem using expressions?
i have a problem displaying my results.
i have created a table with 3 fields: "customername","dealers" and "ISP"
-customername will store names of customer( obviously )
- ISP and dealers data type are just yes/no
lets say i have created a OR expression between "dealers" and "ISP". when i select "dealers" and "ISP".
customername dealers ISP
------------ ------- ---
bob yes yes
cat yes
dog yes
but all i want is BOB's name to appear.
But lets say i use AND expression instead and select the same 2 fields: dealers and ISP
customername dealers ISP
------------ ------- ---
bob yes yes
that will satify my criteria but lets say i only select "dealers", "bob" name will not appear but instead only
"dog" will appear.
thats not i expect, i expect "dog" and "Bob" to appear.
how do i solve this problem using expressions?