=SUM 1

[pmaxon]

I have a column in my report called TG_Count. I have tried placing the following as a page footer or report footer, but neither works. =Sum([TG_Count])

I receive an #Error on my page where the sum should go. The report is produced from a query. Help please...

TIA

 

[PaulF]

try using DSum instead of Sum

=DSum("[TG_COUNT]","YourReportsRecordSourceName")


PaulF

 

[pmaxon]

That worked Paul... Thanks so much!