SSer = Nz(DLookup("EndSerialNo", "qryG2OrderHistory", "AccNo=" & DMax("AccNo", "qryG2OrderHistory")), "N/A")
Hi All
I believe I have invalid syntax here.
What I am trying to achieve is to look up the End Serial value in the query "qryG2OrderHistory" where the AccNo is equeal to the one appearing on a form. I want to return the newest EndSerialNo by using the DMax.
Any suggestions??