Cant use the SectionPages field so you have two options:
1. Easy but short term = hard code the number of pages in the Appendix for those sections
2. Harder but better = add a bookmark on the last page of the appendix and then use a cross reference to that page number in the footers.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia