Dlookup Query

[darreno]

I have qrData with AcctNo and Balance column and would like to pull certain AcctNo with their respective Balances in a report. I tried using Dlookup but failed. This is my code =Dlookup("Balance","qrData","AcctNo=1000")
Or, should I even use Dlookup??

Thanks for any help.

 

[Alc]

Looks like you're almost there.

If AcctNo is a number, the line should read as you have it
=Dlookup("Balance","qrData","AcctNo=1000")

If it's a string, try
=Dlookup("Balance","qrData","AcctNo='1000'")

 

[The_Doc_Man]

Just to be exacting, try

=DLookup( "[Balance]", "qrData","[AcctNo]=... ) - and you fill in whatever account number you were considering.

Alc's comments are right on target, though. You need to know the data type of the field in your query and match that with what you give DLookup.

 

[darreno]

I managed to extract the data. Thanks guys!!