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?
Wing