[AccessD] dynamic sql - changing intermediate query sql on the fly at top level query runtime

Hi Lambert, I read Allen Browne's article
(http://allenbrowne.com/ser-67.html#ColHead). I also did quite a bit of
experimenting. No luck. In order to set that property effectively, you need
to be able to predict what values the data might hold in the field or
expression which it depends upon. Furthermore, Access will not change the
columns in queries downstream of that one. VBA is the only solution to this.