Good morning, all.  I have been working this for some time now and think I have figured some of it out.  In trying to print a report with several title.  lets say job numbers (3 for example).
I print a report let say 7 pages long.  1st job footer number is page 1, but has 3 pages.  2nd job number is 2 page long, footer read page 4 & 5.  Job number 3-footer is 6 and 7...
Now I'm trying to make a table of content.  so im with a query to list the job numbers and get the page number from the report.  this is what I got

ThisPageNumer: [Reports]![ReportNameHere].[PageFooterSection]![PageNumberIs]

query does not return errors but is also does not give me the page number.  What am I missing.  My goal is to return the 1st page number that a job number starts on.  for example

job number 1..................page 1
job number 2..................page 4
job number 3..................page 6

What am I doing wrong?  any feedback is much appriciated.

V/r
Juan