crosstab queries --> YTD calculations

[grantschneider]

I am creating a crosstab query where the heading is a date value (i
have the format in MMM), the row is a text and the values are numbers.
I am hvaing trouble creating a YTD column which differs from a total.
If i set my criteria at a month, the total column gives me totals for
that one month and not YTD

 

[Guest]

It would help if you posted the SQL of your crosstab. You might need to
create a separate totals query that calculates the YTD values by the "is a
text" field. Then join this query with your crosstab in a final query to get
everything you need.