Crosstab Query Question

[Trudye]

Hey Guys, I have a question. I have a table that has two fields that need to be summed in a Crosstab query. Is there a way to accomplish that?

 

[dhookom]

Probably. You can create a value expression like:

TheValue:FieldA + FieldB
Total: Sum
Crosstab: value

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Trudye]

Thanks Duane so much for responding. I'm sorry I now realize my question was vague.

The two fields need to be summed independantly. I need to have sumOfA and a SumOfB. But as you know Crosstabs only allow one value field and one column field.

I guess maybe I'm kinda answering my own question. But I was hoping someone had a trick up their sleeve.

 

[PHV]

Have you read this faq701-4524 ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886