DLookup Functions 1

[ChemistZ]

Is there a way to make the DLookup function return the last value that was entered into a particular field of a table? Or if I have a date field in the table, can I have it return a certain value based on the latest date? I tried something like this

=DLookUp("[PAYMENT]","MASTER_FEE","[FEE_CHANGE_DATE]=MAX([FEE_CHANGE_DATE])&quot

but it isn't working

Any suggestions??

 

[JimHorton]

You need to say
DLookUp("[PAYMENT]","MASTER_FEE",
"[FEE_CHANGE_DATE] IN (select MAX([FEE_CHANGE_DATE]) from master_fee)" )
--Jim

 

[ChemistZ]

BEAUTIFUL - Thank You