hello everyone
when working with access reports using the grouping sections, how do you change the title of the group header section depending on which group is being displayed. i have a report that groups depending on a field called TypeOfReporting . It can either be Complete or Edit. i used the sorting and grouping functionality and it groups all the records depending on if the TypeOfReporting was Complete or Edit. but i want to display the title of the groping result and im failing to do so. In other words when the records are grouped according to a TypeOfRecord which is Complete,i want to put a label Complete and when the groping for the Edit records appears i want to put the label Edit to make it clear for the users.
i tried to put a text called txtTitle in the group header section with the following code
if TypeOfReporting = "Complete" Then
txtTitle = "Complete"
else txtTitle = "Edit"
endif
it didnt work but basically that want im trying to do. i hope this makes sense
thankyou in advance i really appreciate it.
when working with access reports using the grouping sections, how do you change the title of the group header section depending on which group is being displayed. i have a report that groups depending on a field called TypeOfReporting . It can either be Complete or Edit. i used the sorting and grouping functionality and it groups all the records depending on if the TypeOfReporting was Complete or Edit. but i want to display the title of the groping result and im failing to do so. In other words when the records are grouped according to a TypeOfRecord which is Complete,i want to put a label Complete and when the groping for the Edit records appears i want to put the label Edit to make it clear for the users.
i tried to put a text called txtTitle in the group header section with the following code
if TypeOfReporting = "Complete" Then
txtTitle = "Complete"
else txtTitle = "Edit"
endif
it didnt work but basically that want im trying to do. i hope this makes sense
thankyou in advance i really appreciate it.
Comment