I have experienced something in Access that is completely
inexplicable and gives me shivers. I was creating a query inside the
query wizard that I knew should return several records. I ran the
query and it returned no results. I was staring at the design of the
query and moved one of the tables slightly (I did NOT change the type
of join. I simply nudged one of the tables). After doing this, I ran
the query again and it returned several records. Believe it or not.
I will be posting this enigma on YouTube soon for those who cannot
imagine this could happen.
Can anyone, Microsoft employees included, explain why this would
occur?
Vincent