total of count(*) sum

[vassilis]

hi
i add the =count(*) (namefield=XYZ) expression under a group footer into a
report and its working...
when i put the =sum(XYZ) under the report footer im taking an error message.
what im doing wrong?

 

[Ofer Cohen]

The name of XYZ need to be the name of the field in the table and not the
name of the field in the report.

The name of the field in the report XYZ_Report
The name of the field in the table XYZ_Table

Then the Sum will be

=Sum(XYZ_Table)

 

[vassilis]

but i dont have any such field in the table ....i just add a new text box
into my report named XYZ... i thought it could work because access can do
this automaticaly from the new access wizard if you check the sum and summary
choice....

 

[Ofer Cohen]

If you want to know the total of records in the end of the report, then write
again

=Count(*)

The Sum of all count in the group footer will be equal to the count of all
records

 

[vassilis]

yes thanks u have right.

If you want to know the total of records in the end of the report, then write
again

=Count(*)

The Sum of all count in the group footer will be equal to the count of all
records