You can use a LEFT JOIN from Table1 to Table2 if Table1 always has a date or
the reverse if Table2 always has a date.

--
Build a little, test a little.


"Andy" wrote:

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