I have a problem with my cross query,

[nilses]

Hello,

I 've a question with cross query. When I launch my cross query, it created me a new column with that of the zero. If I launch my query, I should have a column Module, a column total of the columns out between module and total, I have a column which names others. Well on I say other because I name it as this but if I do this, I would have a column nevertheless and who names himself < >. Is what there is a means of removing a column because I sending my cross query towards Excel and I am obliged to put hide at my column Others. in Excel

With AUTRES:
TRANSFORM NullDonneZéro(Count([Tbl: DataBase Générale].[No_Appels])) AS
CompteDeSerie
SELECT IIf(IsNull([DataBase: Type de
Module]![CodeReparationCourt]),"AUTRES",[DataBase: Type de
Module]![CodeReparationCourt]) AS [Module], Count([Tbl: DataBase
Générale].No_Appels) AS Total
FROM [DataBase: Type de Module] LEFT JOIN [Tbl: DataBase Générale] ON
[DataBase: Type de Module].CodeReparationCourt = [Tbl: DataBase
Générale].CodeReparationCourt
GROUP BY IIf(IsNull([DataBase: Type de
Module]![CodeReparationCourt]),"AUTRES",[DataBase: Type de
Module]![CodeReparationCourt])
PIVOT IIf(IsNull([Tbl: DataBase Générale].Types),'Autres',[Tbl: DataBase
Générale].Types);

Do you have an idea. Would have you to it even problem with your cross requests

Nilses