ElseIf non rispettata.

[fraude]

Ciao ragazzi.
Perchè di tutte queste condizioni solo quella scritta in rosso non estrae nulla dalla tbl del database, mentre tutte le altre funzionano bene?:

if reg = 0 and prov = 0 and CP = "TUTTI" then
Set rs = DBconn.Execute("SELECT * FROM Scorr ORDER BY regione ASC") 


elseif STATO <> "TUTTE" and reg <> 0 then
Set rs = DBconn.Execute("SELECT DISTINCT RSist.id_reg, Scorr.* FROM Scorr INNER JOIN RSist ON Scorr.id_reg = RSist.id_reg WHERE Scorr.stato = '"&stato&"' AND Scorr.ID_reg = "&reg&" ORDER BY Scorr.regione") 


elseif reg <> 0 and prov <> 0 and com <> "TUTTI" then
Set rs = DBconn.Execute("SELECT DISTINCT RSist.id_prov, RSist.id_reg, Scorr.* FROM Scorr INNER JOIN RSist ON Scorr.ID_prov = RSist.ID_prov WHERE Scorr.regione = '"& regione &"' ORDER BY Scorr.regione") 


elseif reg <> 0 and prov <> 0 then
Set rs = DBconn.Execute("SELECT DISTINCT RSist.id_prov, RSist.id_reg, Scorr.* FROM Scorr INNER JOIN RSist ON Scorr.id_prov = RSist.id_prov WHERE Scorr.ID_prov = "& prov &" ORDER BY Scorr.regione") 

elseif STATO <> "TUTTE" and prov <> 0 then
Set rs = DBconn.Execute("SELECT DISTINCT RSist.id_prov, RSist.id_reg, Scorr.* FROM Scorr INNER JOIN RSist ON Scorr.id_prov = RSist.id_prov WHERE Scorr.stato = '"& stato &"' AND Scorr.ID_prov = "&prov&" ORDER BY Scorr.regione") 



elseif STATO = "TUTTE" then
Set rs = DBconn.Execute("SELECT * FROM Scorr ORDER BY regione ASC")    

 
elseif STATO <> "TUTTE" then
Set rs = DBconn.Execute("SELECT * FROM Scorr WHERE ID_stato = '"& STATO &"' ORDER BY regione ASC") 

elseif reg <> 0 then
Set rs = DBconn.Execute("SELECT * FROM Scorr WHERE ID_reg = "& reg &" ORDER BY reg ASC") 

elseif prov <> 0 then
Set rs = DBconn.Execute("SELECT * FROM Scorr WHERE ID_prov = "& prov &" ORDER BY reg ASC") 

elseif com <> "TUTTI" then
Set rs = DBconn.Execute("SELECT * FROM Scorr WHERE ID_com = '"& com &"' ORDER BY reg ASC") 

end if