crosstab queries --> YTD calculations

G

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
 
D

Duane Hookom

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top