>Furthermore, I put the contents of the source query into a table, changed the broken query to point to the table instead of the source query, and it worked. It seems this issue only exists when I query another query.

Sorry, Mike. I may try to answer this quesiton on Saturday's night, but not today. I'm deadly tired right now and have some work still to do.