I have a crosstab query that outputs the columns Store, FirstNumber, Secondnumber.

I want to also integrate a third column that is equal to the sum of these two fields. Can I do this or do I need a second query?

I use crosstab query a lot.

I have posted an example of how I handle it:
Dynamic Report from Crosstab (click here) (http://www.hitechcoach.com/index.php?option=com_docman&task=doc_details&gid=6&Itemid=28)

Would it be as simple as putting another column in the query design like this?

Thirdnumber: [firstnumber]+[secondnumber]

Would it be as simple as putting another column in the query design like this?

Thirdnumber: [firstnumber]+[secondnumber]

James,

Have you tried that in a Crosstab type query?

I made the assumption that it wouldn't be a crosstab as you can't have more than one value field as far as I know. 9001, how is the data organised then? Which field is the value field? I guess I misunderstood the intended layout....

I made the assumption that it wouldn't be a crosstab as you can't have more than one value field as far as I know. ....

You can by using expressions instead of the inbuilt options