Originally Posted by plog
With all that said, there was still no reason to "cheat" with a DLookup. You could have made another query, using the cross-tab as a data source and the Dlookup data source in there as well to get all the data you needed for your report. Of course that new query would be susceptible to the issues detailed above for your report.
Ultimately this is what I did. I created a new query with the crosstab and the other table with the institution name in it, with a left join between them.
As for the issues with the crosstab query, given the nature of my database and the type of data they are asking me to pull, it is not vulnerable to those problems yet. (That just means I haven't broken it yet.