lookup the most recent date for an entry

[sdel_nevo]

hi All

i have a dlookup working on a form that run when the form is loaded

Order_Payment_Date = DLookup("[Entry Date]", "[Account Transactions]", "OrderID=" & "[Forms].[Edit Orders].[OrderID]")

this finds a entry date from the account transactions table using the orderid from the edit orders form



this works really well, but what i can't seam to find an answer to is this.

how can i lookup the most recent date of an entry?

entry date records dates a payment is made for the order, if there is a payment in the 1st may 2013 and another on the 23rd may 2013, the dlookup does not find the second entry, how can i get dlookup to show the most recent in this case 23rd of may?

Steve

[rzw0wr]

Try using Dmax() function for this.

It has the same syntax as Dloopup()

DMax(Expr, Domain, Criteria)

TIP:
The DMax function ignores Null values in the field referenced by expr. However, if no record satisfies criteria or if domain contains no records, the DMax function returns a Null.

Dale

[sdel_nevo]

Hi Dale

Thanks so much, thats exactly what i was after.

many many thanks

steve