Total from Query not available in Report

[streamranger]

I have a query that is filtering records from a table, I have used the Totals row in the query to Group By and provide Count of totals. The datasheet view of the query has the total row and is working fine. I would like to display the total row on a report, using the query as the record source.

It does not seem to be available, so I put a text box in the footer of the report with the Control Source set to: =Sum([CountOfPermit_Type]), but that only returns an error.

Any suggestions?

 

[madefemere]

Hello,

May be because [CountOfPermit_Type] is not an avalaible field in your report.
Try

=Sum(Count([Permit_Type]))

 

[streamranger]

Thanks, a text box in the report footer did work with the following as its control source

=Sum([CountOfPermit_Type])

I think I fixed something in the underlying query. Ended up abandoning this report for a more elegant crosstab query report.