Allen Browne

[123]

Thank you for your help and answer:



How to use DlookUp to find last value entered in the field and bigest than 0



I take this function from Your site:

=Dlookup (“Fieldname”,”tablename”,”Fieldname” = I don’t know how to convert
the above line…

because the the field my contain null value



thank you

 

[Allen Browne]

If you are trying to match a numeric field with the value of a text box that
could be null, use Nz():
=DLookup("MyField", "MyTable", "Field1 = " & Nz([MyTextBox], 0))

If it is not a numeric field, see:
http://allenbrowne.com/casu-07.html