Crosstab query totals

[Jose]

Hello,

I was wondering if you could help me with a little problem that I have.
I have the following crosstab query

TRANSFORM Sum(Qry_Calcs3.SumOfNet) AS SumOfSumOfNet
SELECT Qry_Calcs3.[Fund Type], Qry_Calcs3.[Fund No], Sum(Qry_Calcs3.SumOfNet) AS TotalDays
FROM Qry_Calcs3
GROUP BY Qry_Calcs3.[Fund Type], Qry_Calcs3.[Fund No]
PIVOT Format([Event Due Date],"Short Date");


This query gives you 60 fields with 60 dates and a total field with value of the 60 dates (TotalDays). I would like to add an extra field where it adds the values of the first 20 dates. Next to this field I would like to add another extra field where it adds the value from date 20 to date 40.

Does anybody know how to get this information?

Thanks for your help in advance

 

[liddlem]

Hi Jose
Unfortunately, I dont have a specific answer for you, but I would consider the following.
1. Create a select query that has a field which identifies the dates into a group, using a group dates per quarter function.
2. Use this query to generate your crosstab.