Access Form Formatting Labels
Posted on 2012-04-11
I have what seems to be to be a tricky problem and I am not sure there is a solution.
I have created a report in Access with 3 grouping levels: toID, stoID, actID. It is sorted in the last group by the actType.
It looks a bit like this:
The activities listed (actID) are divided into tasks and meetings. They are sorted so that tasks will appear first on the list.
What I need is for a label to show up at the beginning of the list that says "Tasks" for all of those with the taskID of 1. Then I need a label that says "Meetings" for those that have a taskID of 2. I need the label to only show up once, so that it looks something like this:
Is this possible?