I need an Excel worksheet or Access report to list our staff's compenation details display in a specific way per attached. I need to add the compensation details to the table/report manually every year for review management review.
This is how I manually input:
1. pre-set a table and organize the data in the same order as the report columns.
2 Add a blank row for each everyone.
3. insert the data pre-set at step 1.
This works only if we are talking about the same group of employee every year! There are cases where they want to look at another group of people or in different order. This manual mapping is driving me crazy!!
Appreciate your comment on a smarter way! heard that drawing report from Access may be faster. Anyone can help me?
