How to filter last date using Dmax

[glen]

Hello,
I have a form "Orders" with sub form "Deliveries"
In one order there are too many deliveries.
every delivery have a delivery date.
I want to filter the last date in delivery dates.
I am using this expression but not working.

=DMax("deliverydate","deliveries","orderid=" & [Forms]![orders]![orderid] & "and deliverydate<#" & [deliverydate] & "#")

Plz tell me what will be the correct expression.


Thanks

[June7]

Where are you using that expression?

Why isn't it working - error message, wrong results, nothing happens?

[glen]

I am using this expression in report in unbound text box. No error but it gives wrong result. I want that when I m in serial 6 in form and I press prieiew it should show me date of serial 5 when I m in serial 5 it should show me date of serial 4 etc. Hoping you will be understand what I want. Thanks

[June7]

=DMax("deliverydate", "deliveries", "orderid=" & [Forms]![orders]![orderid] & " AND SerialNO<" & [SerialNo])

OR

SERIALNO will always be sequential - no gaps?

=DLookup("deliverydate", "deliveries", "orderid=" & [Forms]![orders]![orderid] & " And SerialNO = " & [SerialNo]-1)

[glen]

Yes Serialno will always be sequential.
And I used the first one expression it working nice.
Thank you very much.