In this database that I've been working on for some time, I have a series of four actions that take place and fields that track the dates for these actions. I have created summary queries, using IIF and Totals (Sum), to pull out a number of how many of each events occur in each year. I also have some statistical information tracked on a separate report for each year that tracks percentages as appropriate. What I'd like is a report format that allows me to have the actions across as columns and the years as rows. I'm attaching an image of the kind of thing I have in mind here:
Attachment 57719
I know I can do this with subreports and labels, but I'm hoping there's a way to do it that will look cleaner and will only require creating one item.
Attachment 57719
I know I can do this with subreports and labels, but I'm hoping there's a way to do it that will look cleaner and will only require creating one item.
Report showing multiple actions across multiple years
0 commentaires:
Enregistrer un commentaire