crosstab quey fails in case of table.field syntax is used in subquery

[KemperR]

Dear All,

I have a very hard time with an ACCESS 2000 crosstab query.
The basic query the crosstab is based on looks like this:

SELECT DokumenteNachNummer.Dokumente_ID ,
const_VerteilerCodes.VerteilerCodes_ID ,
Exists (SELECT * FROM Verteiler
WHERE Verteiler.Dokumente_ID =DokumenteNachNummer.Dokumente_ID AND
Verteiler.VerteilerCodes_ID=const_VerteilerCodes.V erteilerCodes_ID) AS
Verteilen
FROM DokumenteNachNummer, const_VerteilerCodes;

As you can see there is an EXIST subquery which just determines if a
certain condition matches. As the field names for the where clause are
in both tables and have the same name I had certainly to prefix the
fileds by the table names. Running the basic query shows the expected
result !
But when I generate a crosstab query and run it I get an error masage
"Mcrosoft Jet database engine does not recognize
'DokumentNachNummer.Dokument_ID'as a valid filed name or expression'
My crossatb sql looks like this:
TRANSFORM First(VerteilerListe.Verteilen) AS FirstOfVerteilen
SELECT VerteilerListe.Dokumente_ID
FROM VerteilerListe
GROUP BY VerteilerListe.Dokumente_ID
PIVOT VerteilerListe.VerteilerCodes_ID;

I think this behaviour is quite odd !
I have nod idea how can I escape from this situation

Any help is highly welcome

Rolf