Sql Code

[sheldondsouza]

Have this sql code but it does not work!

Combo4.text is the therapist name save as text in database
Late is the value stored as Yes/No

sql22 = "select * from Attendance where TherapistName = '" & (Combo4.Text) & "' and Late = True Order by Attendance_Id"

Do you know how to write the exact code

Thanks!

[degsy]

Are you using .NET?

How are you getting Combo4.Text?
Print the variable to make sure it is populated

[sheldondsouza]

Just Visual Basic 6 and connecting it to access

[sheldondsouza]

combo4.text is pulled from database from attendance table

[sheldondsouza]

Got it

sql22 = "select * from Attendance where TherapistName = '" & (Combo4.Text) & "' AND Late = (True) Order by Attendance_Id"

[degsy]

Thanks for the update :)