Add calculated field to Crosstab query ?

R

Rebecca

I have a crosstab query based on a query.
It returns multiple values in columns for weekly totals.
I also want to return a column that is the average of the
weekly totals.
Can I include a calculated field that is not included in
my source query? And if so, how?
 
C

Cameo

In your crosstab query, add a another column.

Field: WeeklyTotalsField
Table: TableName
Total: Avg
Crosstab: Row Heading

This should work.

Cameo
 

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