Unanswered: Issue with Multiple Join and doing comparision
I am using two MS Access tables with multiple field comparision to find out which record does not match in other table. I have attached Design of the query and result which shows incorrect result for the record where both side of the field values are blank. I was wondering how do I handle such DO NOT MATCH comparision query when some of the field has Blank values on both sides ?
Please see attached word document so see the design.
Can't view the doc
But wouldn't it be the not match data would be null there for only show me the null values
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.