Calculate Total Results

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

Guest

I have a report that collects all open work orders. I would like a total
amount of work orders collected in the footer. How do I write this to have
it automatically calculated?

I have something like =Count(*)


Any suggestions would be great

Thanks
 
Hansnanc,
If you have a key field like WorkOrderNo in your report...
=Count([WorkOrderNo])
in the report footer should count all the records.
 
What do you mean by work "orders collected", is there a field that specify
that case, like True False field?
In that case you can write
=Sum(IIf([FieldName]=True,1,0)

If you want to sum a field then
=Sum([FieldName])

To count all the records in the report, then use your example
=Count(*)

All of the above should be in the control source of the field in the report
 
Back
Top