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

How could you work around the crosstab restriction of only allow in value field?

P: 9
Hi everyone, I am working with Access 2003.

I know a crosstab query only allows 1 value field, but how to do you around this restriction?

I have a table with letís say customers, products, calendar year (this field include year 2005-2007), months and a number of expense fields. I was told that to get the sums of products (expenses) per year I need to create a crosstab query. The problem is that some expense fields are added together or grouped together, so I need a new field in the query for each expense group. Therefore I will have many value fields, but only one is allowed in a crosstab query.

Anyone know how to work around this problem?

Thanks in advance.
Dec 19 '06 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
Hi everyone, I am working with Access 2003.

I know a crosstab query only allows 1 value field, but how to do you around this restriction?

I have a table with letís say customers, products, calendar year (this field include year 2005-2007), months and a number of expense fields. I was told that to get the sums of products (expenses) per year I need to create a crosstab query. The problem is that some expense fields are added together or grouped together, so I need a new field in the query for each expense group. Therefore I will have many value fields, but only one is allowed in a crosstab query.

Anyone know how to work around this problem?

Thanks in advance.
Post the crosstab query you are currently using without the added field and explain how you need the result changed. Otherwise it's very hard to follow.

Mary
Dec 21 '06 #2

Post your reply

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