select qiery question

D

Dave

I am using this criteria in a select query:
DLookUp("LastOrderDate","refLastOrderDate")
Click to expand...

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
 
S

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
[email protected]
 
Top