Crosstab query using union query has subquery

[Souris]

I have a crosstab query using an union query.

The crosstabl query works fine before I add a subquery in the union query.

I got "The Microsoft Jet database engine does not recognize
'tblMyTable.MyField' as a valid field name or expression"


The union query running fine without error message.

Does crosstab query support union query with subquery?
If no, are there any workaround?
If yes, are there limitations?


Your help is great appreciated,