Search results

Hello I have a small problem with dlookup multiple criteria. Vba code looks like this: Label34.Caption = DLookup("[Spent_Hours]", "249_1_CHours", "[Date_Added]= " & Me.Text27 & " And [Shift] = '" & Me.Text29 & "'") This gives following error: Syntax error in number in query...