Hi, Am slowly going crazy here trying to solve this so would appreciate any tips/help in this.
Have a database with a list of personnel, the specific year and month, and the hours worked. Want to try and list out, per person, the average hours worked in each of the years for which data is present. Will then use this to chart out. BUT have no idea in how to accomplish this. There are two tables - one with the employee ID and the other with employee iD, the year, month and the hours worked. The two tables are linked by the employee ID.
Am using FMA 11 on a mac os 10.6.4.