A
Alain
Hi to all again,
Can anybody let me know on how to fix this syntax error on the Dlookup
function, Access is pointing the error at the (#" right after the AND, no
matter what I do I am getting the error syntax elsewhere in the criteria
temp2 = DLookup("[Annual OMT]", "Budget BasicRental", "[idbranch] = " & num
& ") _
AND (#" & Format(omtdate, "mm\/dd\/yyyy") & "# Between [from] And [to])"
Many thanks again
Alain
Can anybody let me know on how to fix this syntax error on the Dlookup
function, Access is pointing the error at the (#" right after the AND, no
matter what I do I am getting the error syntax elsewhere in the criteria
temp2 = DLookup("[Annual OMT]", "Budget BasicRental", "[idbranch] = " & num
& ") _
AND (#" & Format(omtdate, "mm\/dd\/yyyy") & "# Between [from] And [to])"
Many thanks again
Alain