total of count(*) sum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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)
 
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....
 
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
 
yes thanks u have right.

Ofer Cohen said:
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
Click to expand...
 
Back
Top