Calculate Total Results

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hansnanc - 31 Oct 2005 14:40 GMT

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

Reply to this Message

Al Camp - 31 Oct 2005 14:50 GMT

Hansnanc,
If you have a key field like WorkOrderNo in your report...
=Count([WorkOrderNo])
in the report footer should count all the records.

Signature

hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

>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
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message

Ofer - 31 Oct 2005 14:56 GMT

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

Signature

If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

> 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
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message