Please help with this line?

F

Foocat

GROUPNAME: DLookUp('" & Left([JOBNUMBER],1 )"' &
"00","tblPROJECTGROUPS","[GYEAR]='" & [Job List].[YEAR] & "'")


This works
","tblPROJECTGROUPS","[GYEAR]='" & [Job List].[YEAR] & "'")


This doesent
DLookUp('" & Left([JOBNUMBER],1 )"' & "00","
 
Top