How can I set my page numbering by group within a report, so that it restarts at page 1 for each group? I tried to follow MS Access help, creating a macro, setting the OnFormat and ForceNewPage properties, etc. but that did not seem to work :(

Check out the following link:

Reports: Printing First and Last Page Numbers for Report Groups (http://www.mvps.org/access/reports/rpt0013.htm)

that didn't work either..i just want to set the page numbering for each group (e.g. 1 of 3, 2 of 3, 3 of 3, etc.), so that each group restarts at page 1. I followed the code used in Access' sample Northwind database for the group header's On Format property:
' Set page number to 1 when a new group starts.
Page = 1
I then set the Force New Page property for the group footer to AfterSection
But my page numbering is still 1 of 48, 2 of 48, etc., 48 being the total number of pages in the report. Am I doing something wrong?

There's no way to know that without seeing your code. Would it be possible for you to .ZIP a sample copy of your database and attach it to this thread so that we can see for ourselves?