Report Pagination Situation

[PaulA]

Greetings, all--

I am running a report that is grouped by a field (in this case, patient name). Data for multiple patients will be printed at a time, with each new patient starting on a new page and a patient possibly filling 2 or 3 pages or more.

I would like to use page numbers specific to the patient grouping--for each new patient the page numbers would restart with "1 of # pages."

Is there a way to do this that doesn't take master coding? I can do some coding but wouldn't know where to start.

Thanks!

Paul

 

[vbaInet]

Do you have a Patient ID field? A field that uniquely identifies each patient. Two or more patients can have the same name so grouping on the Patient Name field is not a good idea.

1. Group on PatientID (not PatientName)
2. Drop a textbox in the Detail section of your report and call it txtCount
3. Enter =1 in the Control Source of txtCount
4. Set the Running Sum property (under the Data tab) of txtCount to Over Group.

If you have multiple groups, this may not give desired results.

 

[stopher]

The challenging bit is getting the values for Pages. The only way I know to do this is presented here using code I'm afraid:
http://access.mvps.org/access/reports/rpt0013.htm

The link takes you step by step through the implementation so hopefully you should have no problems. Just ask if you do.

hth
Chris

 

[PaulA]

Thanks to both of you. I'll check it out--and I will change the grouping to the ID.

 

[PaulA]

Stopher, the link you provided doesn't seem to work. I try again, in case the problem is temporary, but would you know an alternative source for the same information?

thanks.

 

[stopher]

I just tried and it's working fine for me. What browser are you using?

 

[vbaInet]

Do you have a Patient ID field? A field that uniquely identifies each patient. Two or more patients can have the same name so grouping on the Patient Name field is not a good idea.

1. Group on PatientID (not PatientName)
2. Drop a textbox in the Detail section of your report and call it txtCount
3. Enter =1 in the Control Source of txtCount
4. Set the Running Sum property (under the Data tab) of txtCount to Over Group.

If you have multiple groups, this may not give desired results.

I'm almost certain the OP was about having a running count per group before I posted but it turns out it wasn't so I was off point.

Anyway, the link works for me.