Please read/fix this sql statement

[kiwiCoder]

This works if I take out either the > or the = parameter but will not work with both, what have I done wrong.

Set recset2 = cnDataBaseConnection.Execute("SELECT * from Screening WHERE Screening.CinemaNumber= '" & Cine & "' AND Format$(Screening.StartAt, 'DD/MM/YYYY') > = '" & StartDay & "' ;&quot

 

[shavon]

Does it work when it is reversed like this?

=>

 

[f1car]

my VB book saids > = is correct, but maybe you need to remove the space in the middle, as in ">="

 

[kiwiCoder]

Thanks guys the >= no space did the trick, cant believe I didn't try that. People like me give newbies a bad name