Syntax Error

[JEA]

This line keeps throwing an error:

 DLookup("[NoOfStaffRequired]", "Hours", "[DateWorked] = " & WorkedDay)

WorkedDay is a variable passed as a Short Date in to the function. It is Declared As Date.

The [DateWorked] field in the 'Hours' table contains Short Dates.

The error I keep getting is:

Syntax error (missing operator) in query expression '[DateWorked]=00:37:24'.

and:

Run-time error '3075':
|1 in query expression '|2'.

I've got a feeling it's to do with the way I'm concatonating the string. Please help.

 

[RuralGuy]

Try:
DLookup("[NoOfStaffRequired]", "Hours", "[DateWorked] = #" & WorkedDay & "#")

 

[JEA]

It worked

Thanks (again)

 

[KeithG]

Try this

DLookup("[NoOfStaffRequired]", "Hours", "[DateWorked] = #" & WorkedDay & "#")

 

[RuralGuy]

Glad we could help.