Joins on NULL Date values

[Andy]

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

 

[Andy]

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/answers/189228-linking-null-value-fails

 

[Douglas J. Steele]

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

 

[Andy]

I have and it does work. Thanks

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)





.