Missing Operator in query expression

[Indigo]

I have been reading until my eyes are blurry and I can't see what I have missed on this... I am using Access 2010 and trying to get the following statement to work in VBA:

strSQL = "SELECT * FROM qryByTimeEmail" & _
'                     " WHERE qryByTimeEmail.ShiftDate = Between #" & Forms!SearchByTime!SDate & "#" & " And #" & Forms!SearchByTime!EDate & "#" & " And qryByTimeEmail.ShiftID = " & Forms!SearchByTime!ShiftID

Another pair of eyes to see what I am missing would be appreciated. Thank you!

 

[jdraw]

Try

remove this equal sign

..........ShiftDate = Between .....

 

[Indigo]

Yes! I just caught that myself... sigh, TGIF!