Accomplishments
Parishioner data to be compiled and grouped by families (form needed to capture but in development)
enrolled student data tied to parishioner data and to classes
Student enrollment form developed - (need to add one more tab to capture misc. data)
Current Task:
I am trying to track and manage attendance in Access but have some of the Reports look like an Excel format. I.e. dates across the top, and students names down the y axis.
I know I cant have a query add fields/columns but is there a way to have the orientation of the report change axis? I do not want the report to be presented as a series of lists but as a compiled table as I need to consider the full set of data at one time while still capturing it in the background for archiving purposes. :banghead:
Suggestions?
Many thanks!
Trying to set things up right the first time!
CyaNTex
Parishioner data to be compiled and grouped by families (form needed to capture but in development)
enrolled student data tied to parishioner data and to classes
Student enrollment form developed - (need to add one more tab to capture misc. data)
Current Task:
I am trying to track and manage attendance in Access but have some of the Reports look like an Excel format. I.e. dates across the top, and students names down the y axis.
I know I cant have a query add fields/columns but is there a way to have the orientation of the report change axis? I do not want the report to be presented as a series of lists but as a compiled table as I need to consider the full set of data at one time while still capturing it in the background for archiving purposes. :banghead:
Suggestions?
Many thanks!
Trying to set things up right the first time!
CyaNTex