InfoPath Dev

I figured it out.

Hi Jimmy- I figured it out. What I did was make an expression box in the footer, under the column I wanted to sum or average. The expression I wrote to sum my TotalErrors field in my filtered repeating table came out as:  sum(@TotalErrors[msxsl:string-compare(@IndexedDate, startDate) >= 0 and msxsl:string-compare(@IndexedDate, ...

Hi Jimmy. There are two filters on the repeating table:     The expression msxsl:string-compare(concat(substring(@IndexedDate, 1, 4), substring(@IndexedDate, 6, 2), substring(@IndexedDate, 9, 2)), concat(substring(../../my:startDate, 1, 4), substring(../../my:startDate, 6, 2), substring(../../my:startDate, 9, 2))) >= ...

Clay- I need to sum a few columns in my filtered repeating table. How would would you write the sum function if there are two filters on the data? I am using http://www.bizsupportonline.net/infopath2003/filter-repeating-table-date-range-rules.htm  (see steps 14-22). I am using this procedure in my repeating table. Thanks. RhysAZ  

Hello all- I was hoping someone could help me with this. S.Y.M. Wong-A-Ton wrote a great article explaining how to Filter a repeating table on a date range using rules and filters. http://www.bizsupportonline.net/infopath2003/filter-repeating-table-date-range-rules.htm  Unfortunately, I have not found a way to contact her. I followed her ...

Hi Hilary. This will help out a lot. Thanks! RhysAZ

Hi- I'm using IP2003 (Jscript) connected to an Access 2003 database. I would like after selecting a date in my date picker, for the month number to show in a (hidden) text box. Then I would like to use rules in that textbox ("if textbox1=1 then set the value of textbox2 to January", etc) that would set the value of another ...

Thank you again Daniel. Great info!

Thanks qazi_anis. I'll give it a try and let you know how it turns out.

Just so I think I understand you correctly, at the end of each successful rule place a "set the value of " the (newly added) field called "areRulesFired" to "RulesFired" text . Then the code would look for the "RulesFired" text in the "areRulesFired" ...