Warning: A non-numeric value encountered in /home2/icentarb/public_html/icentar/classes/class.permissions.php on line 101

Warning: filesystem::file_put_contents(data/session_del.php): failed to open stream: Permission denied in /home2/icentarb/public_html/icentar/classes/class.filesystem.php on line 142
iCentar
Prikazi cijelu temu 14.05.2015 14:54
miro35 Van mreze
Clan
Registrovan od:05.01.2009
Lokacija:-


Predmet:Re: Kako napisati SQL u VBA
Znači imam ovo:
strSQL = "SELECT * FROM tblPlocice WHERE [Boja]='" & "Bijela" & "' AND [Broj]>='" & OdBroja2 & "' AND [Broj]<='" & DoBroja2 & "'"

Trebam na ovo dodati Between

strSQL = "SELECT * FROM tblPlocice WHERE [Boja]='" & "Bijela" & "' AND [Broj]>=Between'" & OdBroja2 & "' AND [Broj]<='" & DoBroja2 & "'"

Ovo ne prolazi
Miro