select qiery question

[Dave]

I am using this criteria in a select query:

DLookUp("LastOrderDate","refLastOrderDate")

How can I get the results to INCLUDE blank(empty) fields?

can I use "NZ" in any way?

Any help here will be appreciated.

Thanks in advance

 

[Steve]

If that is the only criteria in your query, leave what you have and put the
following in the line below what you have:
Is Null

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Dave]

yep - seems so obvious when you say it like that .
Thanks much

dave

 

[StopThisAdvertising]

If that is the only criteria in your query, leave what you have and put the
following in the line below what you have:
Is Null

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

--
You are *not* a resource at all !!
Stop advertising here, or get lost for another year or so...
http://home.tiscali.nl/arracom/whoissteve.html

ArnoR