If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Joins on NULL Date values
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 |
#2
|
|||
|
|||
Joins on NULL Date values
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 |
#3
|
|||
|
|||
Joins on NULL Date values
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 |
#4
|
|||
|
|||
Joins on NULL Date values
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 . |
Thread Tools | |
Display Modes | |
|
|