Hello!

So the company I work with wants me to redo their metric sheets. Is it possible to do this in Access, I think it very well might be... right now they have them in Excel and it's a complete mess.

We want it to look like:

      (Active department name)     (Today'sDate)

                YearToDate   LastWeek   ThisWeek
                (Dates)      (Dates)    (Dates)
Installed $       $$$$         $$$        $$$
Sq Ft             0000         000        000
Overtime hours    0000         000        000


and then a list of the different departments down the right hand side as buttons you can click on to change to view information for different departments.

(ButtonsForDepartments):
Accounting
Sales
Production
Stone handling
Inventory