Calculations

[Guest]

I have to create a report that needs to give some calculations at the end of
the report. The summary would be:
Items Delivered: ItemDel
Items Installed: ItemInst
Items Pulled after Install: ItemPull
Success Rate: [(ItemInst-ItemPull)/ItemInst]

The report currently pulls from a query that asks for the date range of the
delivered items and how many items were pulled after the install.

ItemDel and ItemInst are fields in the 'Release' table.

How can I get this report to sum all of the ItemDel and ItemInst for the
time period the user selects?

Thank you for your help!!

 

[Marshall Barton]

I have to create a report that needs to give some calculations at the end of
the report. The summary would be:
Items Delivered: ItemDel
Items Installed: ItemInst
Items Pulled after Install: ItemPull
Success Rate: [(ItemInst-ItemPull)/ItemInst]

The report currently pulls from a query that asks for the date range of the
delivered items and how many items were pulled after the install.

ItemDel and ItemInst are fields in the 'Release' table.

How can I get this report to sum all of the ItemDel and ItemInst for the
time period the user selects?

Won't a text box in the report footer with the expression:
=Sum(ItemInst)
do what you want?

 

[Guest]

Thank you very much -- I feel very bad at how simple the solution was -- Doh!!

I have to create a report that needs to give some calculations at the end of
the report. The summary would be:
Items Delivered: ItemDel
Items Installed: ItemInst
Items Pulled after Install: ItemPull
Success Rate: [(ItemInst-ItemPull)/ItemInst]

The report currently pulls from a query that asks for the date range of the
delivered items and how many items were pulled after the install.

ItemDel and ItemInst are fields in the 'Release' table.

How can I get this report to sum all of the ItemDel and ItemInst for the
time period the user selects?

Won't a text box in the report footer with the expression:
=Sum(ItemInst)
do what you want?