Here is an example of what I am trying to accomplish in Access. Is this a fees able spreadsheet to bring over to access by way of tables and queries. What are some strategies to properly do this? Do I need several cross tab queries? Would the use of coding work better? Any help to get me started on the right track would be appreciated.
Thanks,
Nick Clutter