 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / January 2008Subtotal within a Repeating Table
I've created an InfoPath form that receives its data from an Access Database. I have a table in Access that I would like to use in a repeating table, but I want to create a subtotal of one of those fields. I also have a grand total at the bottom of the table. Is it possible to add a subtotal? I've searched quite a bit for this answer, but so far, I haven't found a solution. Any suggestions will be appreciated. Thanks. I am assuming for your grand total this is working and you are using the sum() function. To create a subtotal you do the same thing but instead of Sum(@amount) you would use a filter when selecting the field Sum(@amount[@Type=1]) This would sum just the amounts where type=1 for example. If using the formula builder when you select a field use the filter button in the lower left to set up the filter you need and limit the sum to the subset you define.  SignatureThanks Clay Fox Qdabra Software http://www.qdabra.com InfoPathDev.Com The Largest InfoPath Forum in the World http://www.infopathdev.com > I've created an InfoPath form that receives its data from an Access > Database. I have a table in Access that I would like to use in a [quoted text clipped - 4 lines] > I've searched quite a bit for this answer, but so far, I haven't found > a solution. Any suggestions will be appreciated. Thanks. Thanks. I'll try that. Is there also a way to do this if I don't know what the "type" will be? My table has a list of accounts and then each account has several deal numbers associated with each account. I want to subtotal amounts for the deal number within the account. But I won't know ahead of time what the deal number will be. Thank you. On Jan 14, 2:47 pm, Clay Fox <Clay...@discussions.microsoft.com> wrote: > I am assuming for your grand total this is working and you are using the > sum() function. [quoted text clipped - 22 lines] > > I've searched quite a bit for this answer, but so far, I haven't found > > a solution. Any suggestions will be appreciated. Thanks. You can use a variable in the filter. You may want to research the current() function then you could identify the deal which matches each line. Also might want to look at the preceding:: as well since then you could eliminate duplicate lines and only show each unique deal. SignatureThanks Clay Fox Qdabra Software http://www.qdabra.com InfoPathDev.Com The Largest InfoPath Forum in the World http://www.infopathdev.com > Thanks. I'll try that. > [quoted text clipped - 32 lines] > > > I've searched quite a bit for this answer, but so far, I haven't found > > > a solution. Any suggestions will be appreciated. Thanks. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.