Add calculated field to Crosstab query ?

  • Thread starter Thread starter Rebecca
  • Start date Start date
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?
 
In your crosstab query, add a another column.

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

This should work.

Cameo
 
Back
Top