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

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"123" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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 dont know how to
convert
> the above line
>
> because the the field my contain null value