Dlookup Function

[balajigade]

I've used successffuly the Dmax function in my query-report to find the maximum value of a field "Qagg" in the query "Q1a-bat_br_results" with a criteria where the value of a field "failures" is equal to zero.


=DMax("Qagg","Q1a-bat_br_results","failures = 0")

Now I want to find the value of another field "htno" in the record against the above value of "Qagg" in the same query. I used the following syntax :

=DLookup("htno","Q1a-bat_br_results","Qagg"=DMax("Qagg","Q1a-bat_br_results","failures = 0")")



It isn't working. Pl suggest corrections.

Regards

[June7]

Try:
=DLookup("htno","Q1a-bat_br_results","Qagg=" & DMax("Qagg","Q1a-bat_br_results","failures = 0"))

[balajigade]

Yes, it worked !! Thanks