crosstab reports 1

[FunGuy]

How can I setup a field in a crosstab report that displays the count of records from the underlying table?

 

[elizabeth]

If you base the crosstab on a table and &quot;yes, include row sums&quot; option as you go through the wizard, you can add a field in the report footer to total that column.<br>Just copy & paste that field into the report footer and modify it. If the ControlSource property of the one you copy is:<br>&nbsp;&nbsp;&nbsp;&nbsp;Sum Of CountOfWhatever&nbsp;&nbsp;<br>you would modify the one in the report footer to be:<br>&nbsp;&nbsp;&nbsp;&nbsp;=sum(Sum Of CountOfWhatever)

 

[FunGuy]

For some reason, the &quot;sum&quot; idea does not work.&nbsp;&nbsp;Get an #Error in the text box on the report.....but the idea did remind me of the domain aggregate functions, so I used DCount to do what I needed.&nbsp;&nbsp;Thanks.