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 & "' ;"
Set recset2 = cnDataBaseConnection.Execute("SELECT * from Screening WHERE Screening.CinemaNumber= '" & Cine & "' AND Format$(Screening.StartAt, 'DD/MM/YYYY') > = '" & StartDay & "' ;"