M
Marie via AccessMonster.com
I am using a DLookup function on a report to lookup a budget amount [Mgr
Budget Amount] in a query [qryDeptProdMgrBudget].
The DLookup function worked fine when I only had one criteria e.g. [Funding
Type] = Cash, however I now need to add additional critieria which will match
the [EmplID] field on the report with the [MgrEmplID] field in the query.
I created the expression below, however, the expression is ignoring the
second criteria.
Must be something wrong with the syntax, however, I am stumped.
Any help would be much appreciated!
=DLookUp("[Mgr Budget Amount]","qryDeptProdMgrBudget","[Funding Type]='Cash'"
And "[MgrEmplID] =" & [Report]![EmpID])
Budget Amount] in a query [qryDeptProdMgrBudget].
The DLookup function worked fine when I only had one criteria e.g. [Funding
Type] = Cash, however I now need to add additional critieria which will match
the [EmplID] field on the report with the [MgrEmplID] field in the query.
I created the expression below, however, the expression is ignoring the
second criteria.
Must be something wrong with the syntax, however, I am stumped.
Any help would be much appreciated!
=DLookUp("[Mgr Budget Amount]","qryDeptProdMgrBudget","[Funding Type]='Cash'"
And "[MgrEmplID] =" & [Report]![EmpID])