select qiery question

  • Thread starter Thread starter Dave
  • Start date Start date
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
 
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)
 
Steve said:
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)
Click to expand...

--
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
 
Back
Top