Hello
I'm trying to set Dlookup result as Label caption, but unfortunately I get error message:
Run time error '3075':
Syntax error in number in query expression '[Date_Added]=4.02.2015 And [Shift] = '1'.
Dlookup looks like this:
Label34.Caption = DLookup("[Spent_Hours]", "249_1_CHours", "[Date_Added]= " & Me.Text27 & " And [Shift] = '" & Me.Text29 & "'")