Hi All,

What is wrong with this SQL statment, as VB does not like it

VB Code:
  1. rst.Open "SELECT Controller.FirstName, Controller.Lastname, Controller.Time, Controller.Teachers_Name From Controller=WHERE (((Controller.Time)="17:00") AND ((Controller.Teachers_Name)="Lauren ellis"))", Adodc1.ConnectionString, adOpenKeyset, adLockOptimistic

Thnaks

Loftty