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","
"00","tblPROJECTGROUPS","[GYEAR]='" & [Job List].[YEAR] & "'")
This works
","tblPROJECTGROUPS","[GYEAR]='" & [Job List].[YEAR] & "'")
This doesent
DLookUp('" & Left([JOBNUMBER],1 )"' & "00","