Syntax Error

[lotus18]

Can you spot the syntax error? When I try to use this it says "Syntax error (missing operator) in query expression"

Dim strSQL$
strSQL = "SELECT * FROM LoadSchedule WHERE " & _
                    "(DayA = '" & Day1 & _
                     "' AND Rooms.Title = '" & Room & _
                     "' AND Courses.Title = '" & Course & _
                     "' AND Sections.Title = '" & Section & _
                     "' AND Semester = '" & Semester & _
                     "' AND ((TimeStarted <= #" & TimeStarted & "#" & _
                     "  AND TimeFinished => #" & TimeStarted & "#)" & _
                     "  OR (TimeStarted => #" & TimeStarted & "#" & _
                     "  AND TimeSTARTED =< #" & TimeFinished & "#)))" & _
                     " OR " & _
                     "(DayB = '" & Day2 & _
                     "' AND Rooms.Title = '" & Room & _
                     "' AND Courses.Title = '" & Course & _
                     "' AND Sections.Title = '" & Section & _
                     "' AND Semester = '" & Semester & _
                     "' AND ((TimeStarted <= #" & TimeStarted & "#" & _
                     "  AND TimeFinished => #" & TimeStarted & "#)" & _
                     "  OR (TimeStarted => #" & TimeStarted & "#" & _
                     "  AND Timestarted =< #" & TimeFinished & "#)))"
 
        adRecordset.Open strSQL, dbConnection, 1, 1

[Killer42]

Is it possible that it doesn't like the operator "=>"? I've always used ">=" but don't know whether it matters.

In any case, I'd recommend you print out the actual value of strSQL and paste it here for us to see.

[CyberSoftHari]

Killer is correct the query string will not validate => (equal or greater), It should be >= (Greater or equal) and as well =<.

[lotus18]

Hi

I think you're right. Thanks. LOL

Rey Sean

[Killer42]

Let us know how it turns out.