?
Solved

Sum column entry in subreport based on data not field name

Posted on 2008-10-01
5
Medium Priority
?
266 Views
Last Modified: 2008-10-02
The main report has the consignor information and the subreport shows the detail for each item they had for sale.

The description field is call DESC and it will have various thing entered in it....Collected, Uncollected, Commission, Classic, Fee, Miscellaneous.

I need to get a separate grand total for all the items that the description is (Collected, Commission, Classic, Fee and Miscellaneous). Then those totals need to be in the main form. The field name for the amounts in the subreport is AMOUNT. So I end up with a grand total for Collected, a grand total for Commission etc. on the main report for each consignor.
 
This is the output of the subreport.

Item #               Price                 Description        Amount       <---  (heading)
1                      1000.00             Collected            1000.00
(dup hidden)    (dup hidden)     Commission          500.00
(dup hidden)    (dup hidden)     Fee                       275.00

10                      2000.00           Collected            1000.00
(dup hidden)    (dup hidden)     Commission          500.00
(dup hidden)    (dup hidden)     Fee                       275.00

Main Report (at end for the Consignor)
                                                 Collected            2000.00
                                                 Commission        1000.00
                                                 Fee                       500.00

Each consignor has a separate report.

Can anyone help...?

0
Comment
Question by:proffittware
  • 3
  • 2
5 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 2000 total points
ID: 22621719
Sounds like another subreport just showing the totals is the way to do this.
0
 

Author Comment

by:proffittware
ID: 22623473
Ok...

Group on description and totals ?
0
 
LVL 77

Assisted Solution

by:peter57r
peter57r earned 2000 total points
ID: 22624506
Yes- that would be my view.
0
 

Author Comment

by:proffittware
ID: 22627087
I will try and get back with you.
0
 

Author Comment

by:proffittware
ID: 22629092
Thanks...that worked...
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question