Help w/Totals on Reports

T

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
 
A

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
 
T

teelee

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

akphidelt said:
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 said:
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
 
T

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

akphidelt said:
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 said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top