Using Max Function to display latest record

[jamarogers]

I am trying to display (on a form, OneSideOfRelationship) the last "Date" of an item purchased in a related table(ManySideOfRelationship). I am using " =Max(DLookUp("POItDteRcd","POItems","POItNme = Forms![Inv]![InvName] And POItSize= Forms![Inv]![InvSize]")) " but nothing is returned and I get no error. The "DLookUp" works fine, but when I add the "Max" function, all I get is an empty field. Can someone please advise?

[ItsMe]

I am trying to display (on a form, OneSideOfRelationship) the last "Date" of an item purchased in a related table(ManySideOfRelationship). I am using " =Max(DLookUp("POItDteRcd","POItems","POItNme = Forms![Inv]![InvName] And POItSize= Forms![Inv]![InvSize]")) " but nothing is returned and I get no error. The "DLookUp" works fine, but when I add the "Max" function, all I get is an empty field. Can someone please advise?

I goofed and posted my earlier response in the wrong thread!

I don't know the answer to your problem but I will take a look at it. Sorry for my earlier response.

[ItsMe]

The only thing I see wrong is that you added max in front of a functioning DLookup statement. The following should display the max date.

DMax("POItDteRcd", "POItems", "POItNme = Forms![Inv]![InvName] And POItSize= Forms![Inv]![InvSize]")

[jamarogers]

Thanks for that...did not know about DMax...here's my final expression, which worked fine:
=DLookUp("POItCost","POItems",'POItNme = Forms![Inv]![InvName] And POItSize= Forms![Inv]![InvSize] and POItDteRcd =DMax("POItDteRcd","POItems","POItNme = Forms![Inv]![InvName] And POItSize= Forms![Inv]![InvSize]")')
This looks through the POItems and selects the Cost for the Latest received PurchaseOrderItem.

[ItsMe]

Glad you got it going