I have a calculated control in a report that does a lookup. Can't seem to get the concatenation right.
=DLookup("[MGR ID] & "- " & [MGR NAME], "tbl MGR LIST", "[MGR ID]="'& [MGR]& "'"
Everything else works okay but can't get the [MGR ID]/[MGR NAME] to work. The result should be, for example, 23- JOHN DOE.
Thanks...
=DLookup("[MGR ID] & "- " & [MGR NAME], "tbl MGR LIST", "[MGR ID]="'& [MGR]& "'"
Everything else works okay but can't get the [MGR ID]/[MGR NAME] to work. The result should be, for example, 23- JOHN DOE.
Thanks...