I found this post where Microsoft gives the solution... execute the string variable within a string variable. Double your single quotes, double your fun!

http://support.microsoft.com/kb/314520

I found this post on how to get page numbers by group.

http://blogs.msdn.com/chrishays/archive/2006/01/05/ResetPageNumberOnGroup.aspx

However, I wanted the format "page x of x". This example doesn't handle that,...