Two aggregates in a crosstab

[bobfin]

I have a working crosstab query with Account for Row Heading and Entered-Date for Column Heading. The Value column is the average of a currency field. This query is the source for a report. Now my boss, in his endless quest for "one more thing", wants to knows how many items went into each average. He wants each number on the report to show Average/Count instead of just the Average. I've toyed with multiple queries but keep running into the crosstab's limitations. Any idea how to do this?

 

[bobfin]

A solution is to use 2 queries. The 1st query is a totals query that groups by Account and Entered-Date. It has the Average and Count values. The 2nd query is a crosstab query which uses the 1st query as source. The Value column is a concatenation of the Average and Count fields.