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