adding up data and numbering table rows?
question 1. I have a repeating table. One column should show what number row it is. AllI have now is each row has a 1 as its number. I would like each row to be numbered individually.
Question 2. in my database table each record has a column for month day and year as well as a column that holds a number (0, 1, 0r 2). Then I have table that I would like to add up all of the numbers for a particular date. If the recordset returns info for 10/12/09 then i would like for it to add all the numbers in that column. Lets say there are 3 entries for 10/12/09, each entry has a 2 in its number column. the table cell should display a 6.