Dlookup Question (I should know) (1 Viewer)

[melodyF]

I'm trying to use Dlookup to pull a value from a query into a report:
ThI want the Salary where the field section is BankPro..

=DLookUp("Salary","qryChartQtr2","Section = BankPro")
The value of BankPro is text.

Thanks for the help...

 

[RichMorrison]

you wrote
<<
=DLookUp("Salary","qryChartQtr2","Section = BankPro")
The value of BankPro is text.
>>

Should be
=DLookUp("Salary","qryChartQtr2","Section = 'BankPro'")
with single quotes around BankPro

RichM