I have and it does work. Thanks

"Douglas J. Steele" wrote:

Have you tried it? You may find that its performance is still acceptable.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele/AccessIndex.html
Co-author: "Access 2010 Solutions", published by Wiley
(no private e-mails, please)


"Andy" wrote in message
news
I am trying to avoid this solution as my tables are VERY large and it says
that it is not very efficient.
http://bytes.com/topic/access/answer...ll-value-fails

"Andy" wrote:

I have some queries whereby I need to join two tables based on two date
fields that are in both queries. Sometimes date 1 or date 2 will have
NULL
values, but I still need to perform the join accurately which doesn't
work.

I cannot amend the values in the table to a default date (#01/01/1000#)
as
it comes from a SQL process that cannot be ammended. Any thoughts? 1:1
join.

Ta


.