Grouping report

[ayamnash]

I have a salary table that has four levels for an employee's workplace

Any employee may have two , three or four levels for determine his workplace.
I made a report to know the sum of each of the four levels, But it design is not good I want to be the report like this

Any help?

 

[MajP]

Is this correct

 

[arnelgp]

see your report.

 

[ayamnash]

This is a better design.
Thanks

 

[Pat Hartman]

When two people offer different solutions, you might want to specify which you liked best.

 

[Pat Hartman]

@ayamnash,
You've been a member for 5 years but you don't do much posting. Looks like you only come when you need an expert to help you. You got lucky this time. Two of our best gave their time to actually make you a sample.

 

[ayamnash]

I have quite a bit of knowledge of ms access but the main reason I didn't post is that my English is not perfect

 

[Pat Hartman]

You would be amazed at what we see posted by native English speakers. Perfection isn't necessary. Try the conversion programs. Sometimes they make us laugh but do tell us that you used a converter so we know what we are looking at