Help w/Totals on Reports

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

teelee - 29 Mar 2008 22:35 GMT

I have a SubForm and Report with ways for purchases, there are 3 ways in
which these purchases can be bought - WebSite, Direct Pay, and E-Plans. I
have the cost minus the Cost of Purchase minus EPlan minus the Trip Charge
minus the Auth Charge, also the Web Charge minus the Trip Charge minus the
Auth Charge, Direct Has nothng but Direct Pay. How can I calculate this on
the Subform Totals and the Report Totals.

Thanks in Advance

Reply to this Message

akphidelt - 29 Mar 2008 22:54 GMT

Right click on the SubForm and go to Open in new Window. Then in that new
window use that like any other report you do and either under the Report
Footer or the footer of the item you are ordering by. Then type in your
equation.

The regular report you can just go to the report footer of that and type in
the equation.

Reports go in order.
So if you group by the date and under the date footer, you put
Sum([Cost])... it will sum all the cost for that specific date.

Then if you go to the report footer and put Sum([Cost]) it will Sum the
costs of all the dates shown.

Same thing goes for SubReports

> I have a SubForm and Report with ways for purchases, there are 3 ways in
> which these purchases can be bought - WebSite, Direct Pay, and E-Plans. I
[quoted text clipped - 4 lines]
>
> Thanks in Advance

Reply to this Message

teelee - 29 Mar 2008 23:05 GMT

I don't have a Open in New Window, I'm working in 2007.

> Right click on the SubForm and go to Open in new Window. Then in that new
> window use that like any other report you do and either under the Report
[quoted text clipped - 21 lines]
> >
> > Thanks in Advance

Reply to this Message

teelee - 29 Mar 2008 23:11 GMT

On My Report I have Customer Name, Product name, Purchase Method, Date Sold.
I can't seem to get the Total Sales to show up on the Form or Report. Do I
have to make another Form for the Totals?

Thanks

Reply to this Message