Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Empty data are automatically filtered in Queries
Message
 
 
To
09/05/2002 17:00:03
Jason Dalio
Northern Interior Regional Health Board
Prince George, British Columbia, Canada
General information
Forum:
Microsoft Office
Category:
Access
Miscellaneous
Thread ID:
00654161
Message ID:
00654807
Views:
27
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform