Recordset Given too few parameter error

[boywonder381]

I'm getting the following error:

Runtime Error '3061'

Too few parameters. Expected 1.

=====

Here's my recordset setup:

'Grab count of all employee attending a class
strEmployee = "SELECT * FROM [TEmployee] WHERE " & _
"(((TEmployee.Shift) = '" & strShiftName & "') AND " & _
"((TEmployee.Courses) = '" & strCourses & "') AND " & _
"((TEmployee.Classroom) = '" & strClass & "') AND " & _
"((TEmployee.StartTime) = #" & Format(dStartTime, "h:nn") & "#) AND " & _


"((TEmployee.EndTime) = #" & Format(dEndTime, "h:nn") & "#) AND " & _
"((TEmployee.SchedDate) = #" & Format(dClassDate, "m/d/yyyy") & "#))"

Set rsEmployee_Headcount = dbs.OpenRecordset(strEmployee)
j = rsEmployee_Headcount.RecordCount

What I'm I doing wrong...

[boywonder381]

I fixed it. I'm just tired. It was the TEmployee.Shift, should be TEmployee.Shifts. Good night.