Help w/Totals on Reports

[teelee]

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

 

[akphidelt]

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

 

[teelee]

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
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
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

 

[teelee]

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

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
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