Outputing 1 report for every record in a recordset

[branston]

Hi,

I have a report which needs to be output. What I want to do is output the report for each discipline, however, for the page numbering/headings etc to work I need to output a report for each discipline seperately.
eg:
DoCmd.OpenReport "RepStatus", acViewPreview, , "[Discipline] = '" & Me.ComboDiscipline & "'"

Is there a way to do this for every record in a table (i.e. a table with a list of all the disciplines)? Ive never got a loop to work correctly, so any help would be much appreciated

Also, in an ideal world, i would want all these sepereate reports to concatenate into either 1 report or a PDF file. Is that possible?

Thank you!!!

 

[Mr. B]

Have you considered grouping your report by discipline and set the New Page after the footer of the discipline group. You can reset the page numbering for each grop.

Here is link that may help:
http://www.access-programmers.co.uk/...threadid=31319

 

[branston]

Ah, I did try putting the page number in the footer, but i didnt know how to re-set it. Now i know its possible ill have a look. The link doesnt work though.
Ill let you know how it goes!
Thanks!

 

[branston]

Right, Thanks again Mr.B. That worked great... but... Is there any way to do teh same thing with the total number? I want a "Page a of b" type thing, but at the moment i can only figure out how to reset the a, the b is still showing the total number of pages in the report!

 

[Mr. B]

Sorry about the link not working, I copied it from another thread so I just assumed it would work. I you search here you will find it.

Good luck with your project.