>Sorry Nadya. I was trying to explain that you needed to fix the first problem before the second. The reason that your blank dates are not being returned is that they are not in fact blank. They are Null and nothing can ever equal Null; including Null. So the JOIN cannot work becasue there is nothing to JOIN to.
They are not shown as NULL, they are shown as empty. Is it the same in Access?
If it's not broken, fix it until it is.
My Blog