D
Dave
Hi folks,
Picture a simple expense form with multiple rows. Each row has some detail
including a cost code and a total amount. Now picture the form filled out
with 5 rows. 2 rows are for cost code "A", 2 rows are for cost code "B" and
1 row is for cost code "C".
In the bottom portion of the form, I would like to automatically create a
sub-total field for each cost-code used within the form, in the example, 3
fields for A,B & C. Other times there might just be 1 cost code, or let's
say the maximum might be 6 cost codes.
So, how can I dynamically create the sub-total fields and provide them with
dynamically generated expressions based upon the actual cost codes entered.
I thinking these would use a Sum funtion with an XPath Filters expression.
I've done this before in Excel and I'm sure I could do it with Access but
sure could use some help with InfoPath.
Thanks!!!!
Picture a simple expense form with multiple rows. Each row has some detail
including a cost code and a total amount. Now picture the form filled out
with 5 rows. 2 rows are for cost code "A", 2 rows are for cost code "B" and
1 row is for cost code "C".
In the bottom portion of the form, I would like to automatically create a
sub-total field for each cost-code used within the form, in the example, 3
fields for A,B & C. Other times there might just be 1 cost code, or let's
say the maximum might be 6 cost codes.
So, how can I dynamically create the sub-total fields and provide them with
dynamically generated expressions based upon the actual cost codes entered.
I thinking these would use a Sum funtion with an XPath Filters expression.
I've done this before in Excel and I'm sure I could do it with Access but
sure could use some help with InfoPath.
Thanks!!!!