Greetings, all.
I use Access 2007.
I have a report with the following Group/Sort configuration:
1: Sort by Patient Name
2: Group by Patient ID
3. Group by Discipline
4. Sort by Discipline
I have page breaks in both patient id and discipline grouping footers.
I want the patient name on the top of every page so I have that field in the page header, as well as in the Patient ID grouping header. I am finding that the value in the page header field is delayed one page so that the value in the grouping header doesn't match the value in the page header for one page.
I have tried different grouping/sorting configurations to fix this but have been unsuccessful.
Any ideas on how to have the page header value change with the group header value in this situation?
Thanks!
Paul
I use Access 2007.
I have a report with the following Group/Sort configuration:
1: Sort by Patient Name
2: Group by Patient ID
3. Group by Discipline
4. Sort by Discipline
I have page breaks in both patient id and discipline grouping footers.
I want the patient name on the top of every page so I have that field in the page header, as well as in the Patient ID grouping header. I am finding that the value in the page header field is delayed one page so that the value in the grouping header doesn't match the value in the page header for one page.
I have tried different grouping/sorting configurations to fix this but have been unsuccessful.
Any ideas on how to have the page header value change with the group header value in this situation?
Thanks!
Paul