Hi,
I would like to be able to display a label based on criteria. My criteria is if any of the values in a column are equal to "High". For example my SQL query would be something like:
SELECT COUNT(*) AS CALL_PRIORITY
FROM CL_CALL_LOGGING
WHERE (CALL_PRIORITY = 2)
My vb script being something like the below. Basically need help in saying "If the SQLdataquery rowcount is >1 Then"
If ****************** Then
Label1.Visible = False
Label2.Visible = True
Go to the complete details ...