By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,965 Members | 1,170 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,965 IT Pros & Developers. It's quick & easy.

Crosstab Query

P: 51
I have a crosstab query for 12 months of sales. It works well except is adds all the months sales together for every year. Does not seperate 2009 from 2008 and so on. It sums all the years together per month.

Column 1
Field: Salesrep
Table: tblJob
Total: Group By
Crosstab: Row Heading

Column 2
Field: Expr1: Format([BoardDate],"mmm")
Total: Group By
Crosstab: Column Heading

Column 3
Field: SaleAmount
Table: tblJob
Total: Sum
Crosstab: Value

Column 4
Field: Total Of SaleAmount: SaleAmount
Table: tblJob
Total: Sum
Crosstab: Row Heading


I tired to insert a column for [boarddate] and put in "year(now())
I tried to insert in column 2 "year(now())
I tired literally 30 to 40 other combinations.
Come up with either no results or errors.

Need Help!
Thanks
Gary
Aug 2 '09 #1
Share this Question
Share on Google+
1 Reply


P: 51
I just worked it out -
thanks
Gary
Aug 3 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.