using the left function within a DLookup

[crowegreg]

Can you use the left function in the criteria within a DLookup statement? I don't know if's my syntax, or I'm trying to do something that is not possible.



Here's my code:

Me.Group = DLookup("[VP Position Description]", "ITS_Operations_SVP", Left([ACCT UNIT],4) = & Me.Combo48)

[crowegreg]

It was my syntax. Here's what works

Me.Group = DLookup("[VP Position Description]", "ITS_Operations_SVP", "left([ACCT UNIT],4) ='" & Me.Combo48 & "'")