How to use AND operator Sql in ADO query VB6 data selecting error ?

strsql = "Select * from PHC_Master where Block_id=" & blockcombo.ItemData(blockcombo.ListIndex) & " AND block_master.status='Y' " my program is working on only the result of first query statement but does not covering second condition plz give me my right code. how should I create select statement so it takes... show more strsql = "Select * from PHC_Master where Block_id=" & blockcombo.ItemData(blockcombo.ListIndex... & " AND block_master.status='Y' "

my program is working on only the result of first query statement but does not covering second condition plz give me my right code. how should I create select statement so it takes second statement also that is AND block_master.status=Y " plz correct my this code so it select row where both the condition are true phc_master and block_master are different ms-access table related through block_id
2 answers 2