i have created a repeating table that has a drop down to show expense

type and three subsequent columns for previous amount, change amount

and total. i have also added a footer to the repeating table to sum

each of the columns. the formula i used to autopopulate the footer

text boxes with the sum of the repeating table rows is :

sum_previous_Amount: sum(@previous_Amount). My data is linked via an

Access database.

the problem is that the function only sums the first row. any added

rows within the repeating table are not captured as part of the sum.

i followed microsoft's directions to sum the columns, so i'm at a

loss. any help would be greatly appreciated!!!

rick

Hi Rick,

Insert formula "sum(field)" for Footer text box default value, This may

solve your problem

--

Ravi G

Insert formula "sum(field)" for Footer text box default value, This may

solve your problem

--

Ravi G

Hi,

Check whether pdate this value when the result of the formula Check

box is checked or not in the footer text box properties. If it is not checked

then check this one.

--

Swathi Porandla

http://www.yqcomputer.com/

> > i have created a repeating table that has a drop down to show expense> > type and three subsequent columns for previous amount, change amount> > and total. i have also added a footer to the repeating table to sum> > each of the columns. the formula i used to autopopulate the footer> > text boxes with the sum of the repeating table rows is :> > sum_previous_Amount: sum(@previous_Amount). My data is linked via an> > Access database.> > > > the problem is that the function only sums the first row. any added> > rows within the repeating table are not captured as part of the sum.> > i followed microsoft's directions to sum the columns, so i'm at a> > loss. any help would be greatly appreciated!!!> > > > rick> >

Check whether pdate this value when the result of the formula Check

box is checked or not in the footer text box properties. If it is not checked

then check this one.

--

Swathi Porandla

http://www.yqcomputer.com/

> > i have created a repeating table that has a drop down to show expense> > type and three subsequent columns for previous amount, change amount> > and total. i have also added a footer to the repeating table to sum> > each of the columns. the formula i used to autopopulate the footer> > text boxes with the sum of the repeating table rows is :> > sum_previous_Amount: sum(@previous_Amount). My data is linked via an> > Access database.> > > > the problem is that the function only sums the first row. any added> > rows within the repeating table are not captured as part of the sum.> > i followed microsoft's directions to sum the columns, so i'm at a> > loss. any help would be greatly appreciated!!!> > > > rick> >

1. =sum(A:A) add to column (B) and new value repeats w/ new sums

2. Sum of rows does not tie to sum of columns

3. How to Sum<=40, sum, if >40 sum in next column

4. Cumulative summing: sum rows 1-12, then rows 1-24, 1-36, etc..

5. Need to sum row 7 columns based row 8 columns that are not Bla

6. Need to sum row 7 columns based row 8 columns that are not Blank

7. UPDATE MULTIPLE ROWS IN ONE TABLE OBTAINING SUMS FROM ANOTHER TABLE

8. SUM IF: How do I sum the data in a column based on 2 other columns

9. How to add previous sums in a column to current sums in a column?

10. Select Sum(table1.column), Sum(table2.column)

11. XPath for summing qty for unique rows in repeating table?

12. HELP - Customer Budget Sales repeated on fact tables rows: SUM or MAX?

13. Pivot table experts: using sums instead of counts in repeated columns

14. table columns that are SUM of other columns in other tables

15. Need to Sum one column for each row that is part of a group and th

3 post • Page:**1** of **1**