Prev: Retrieve all record if check box = 0 (Not checked)
Next: Access 2K2: making numbers up in a query sum
From: KARL DEWEY on 27 May 2010 16:40
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/answers/189228-linking-null-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
 | 
Pages: 1
Prev: Retrieve all record if check box = 0 (Not checked)
Next: Access 2K2: making numbers up in a query sum