Qry: Crosstab Query with a few value's

[Jordan2000]

Hello,

I have a question on a Database I'am building.
I need to make a Query that wil Compare Current YTD against Last YTD with Budgets and Outlook until End of Year,

I have got one query that is showing Current YTD Fields like
Dealer
Gross Value
Customer Margin
Invoice Value
our Margin or profit
Cost Value
and compare these values with Last YTD values.

Is this posible in Access ?
I know it is possible in Excell with Crosstabels. but Access wont let me add more than one value in the Cross table Query.

SELECT Invoices_By_Item.Jaar, Invoices_By_Item.Kwartaal, Invoices_By_Item.Maand, Invoices_By_Item.[Week#], Invoices_By_Item.[Afnemer groep], Invoices_By_Item.CAT1E1, Invoices_By_Item.CAT4E1, Sum(Invoices_By_Item.Aantal) AS Aantal, Sum(Invoices_By_Item.[Bruto waarde]) AS [Bruto waarde], ([Bruto waarde]-[Netto waarde])/[Bruto waarde] AS Dealermarge, Sum(Invoices_By_Item.[Netto waarde]) AS [Netto waarde], ([Netto waarde]-[Inkoop waarde])/[Netto waarde] AS PAHmarge, Sum(Invoices_By_Item.[Inkoop waarde]) AS [Inkoop waarde]
FROM (((Invoices_By_Item INNER JOIN [0,0 - CAT1 & Desci] ON Invoices_By_Item.CAT1E1 = [0,0 - CAT1 & Desci].[Category 1 Code - IN04]) INNER JOIN [0,0 - CAT2 & Desci] ON Invoices_By_Item.CAT2E1 = [0,0 - CAT2 & Desci].[Category 2 Code - IN04]) INNER JOIN [0,0 - CAT3 & Desci] ON Invoices_By_Item.CAT3E1 = [0,0 - CAT3 & Desci].[Category 3 Code - IN04]) INNER JOIN [0,0 - CAT4 & Desci] ON Invoices_By_Item.CAT4E1 = [0,0 - CAT4 & Desci].[Category 4 Code - IN04]
WHERE (((Invoices_By_Item.CAT2E1)="ACD" Or (Invoices_By_Item.CAT2E1)="ACG" Or (Invoices_By_Item.CAT2E1)="ACI" Or (Invoices_By_Item.CAT2E1)="ACL" Or (Invoices_By_Item.CAT2E1)="ACM" Or (Invoices_By_Item.CAT2E1)="ACS" Or (Invoices_By_Item.CAT2E1)="ACT" Or (Invoices_By_Item.CAT2E1)="ACV" Or (Invoices_By_Item.CAT2E1)="ACW" Or (Invoices_By_Item.CAT2E1)="ACX" Or (Invoices_By_Item.CAT2E1)="ACZ"))
GROUP BY Invoices_By_Item.Jaar, Invoices_By_Item.Kwartaal, Invoices_By_Item.Maand, Invoices_By_Item.[Week#], Invoices_By_Item.[Afnemer groep], Invoices_By_Item.CAT1E1, Invoices_By_Item.CAT4E1
HAVING (((Invoices_By_Item.Jaar)=[J,2 - Accessoire op Cat 4]![Jaar]-1) AND ((Sum(Invoices_By_Item.Aantal))<>0));

Hope you could help me on this issue.

Thanks in advanced