iif statement

[Guest]

I have the following statement
=IIf([TaxDocStatus]<>"Pending",Max([TxDocDateRcvd]),"")

the thing is that when I use this in a report, it give the max date of all
the records but what am really interested in is that it should be for each
borrower [BorrowerID] as they would be different.... Any idea how I can do
that

 

[John Vinson]

I have the following statement
=IIf([TaxDocStatus]<>"Pending",Max([TxDocDateRcvd]),"")

the thing is that when I use this in a report, it give the max date of all
the records but what am really interested in is that it should be for each
borrower [BorrowerID] as they would be different.... Any idea how I can do
that

You'll need to use the DMax() function: Instead of
Max([txtDocDateRecvg]) use

DMax("[TxDocDateRcvd]", "[YourTableName]", "[BorrowerID] = " &
[BorrowerID])

assuming that the table fieldname is in fact txDocDateRcvd and using
your own table name.

John W. Vinson[MVP]