I have the same problem as Skip. The query worked fine, then when I tried to create a Query of the two Query results, i started getting the Invalid name error. The Query name is "Weekly Report" and now I can't execute the query, only view it in design mode.
Any Help??? Please?!