Excel Urgent help in Excel / Access Report

Oct 22, 2015
Reaction score
Masked Report.PNG
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?



Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question