Calculations

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

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!!
 
binder said:
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?
Click to expand...


Won't a text box in the report footer with the expression:
=Sum(ItemInst)
do what you want?
 
Thank you very much -- I feel very bad at how simple the solution was -- Doh!!

Marshall Barton said:
binder said:
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?
Click to expand...


Won't a text box in the report footer with the expression:
=Sum(ItemInst)
do what you want?
Click to expand...
 
Back
Top