Hi, I am trying to create a report that has a table format with rows for Location and columns for status. This report shows the total number of Books sent to different locations (listed in rows)& their status (listed in columns) respectively. Here are the basics of my design for the 'Book' table:
Book
------
Book #
Status ->Issued = Returned Used + Returned Unused + Missing
These are listed in cloumns and their count is needed by
Location-> 20 locations listed in rows
It should be pretty simple with controls but I need to know the exact format to be used to create the controls.
Book
------
Book #
Status ->Issued = Returned Used + Returned Unused + Missing
These are listed in cloumns and their count is needed by
Location-> 20 locations listed in rows
It should be pretty simple with controls but I need to know the exact format to be used to create the controls.
