aggregate function inside an aggregate function

[Hecronis]

Hey,
I'm trying to use an aggregate function inside another aggregate function and I'm having a difficult time. I don't really know what all I need to put in here. Here is what I have:

dlookup("Amount_Owed", "TblRent_OwedAtDischarge", "ID_RentOwed = " & DMax(""ID_RentOwed"", ""TblRent_OwedAtDischarge"", "ID_Number = "" & "[forms]![FrmClient_Info]![ID_Number1]'"")"))

Each "Amount_Owed" has an auto-number "ID_RentOwed" associated with it and a clients ID_Number. I need to look up what the most recent amount owed is for for a client.

 

[pbaldy]

Would this work?

http://www.baldyweb.com/LastValue.htm