Grouping report (1 Viewer)

ayamnash

New member
Local time
Today, 13:10
Joined
Sep 23, 2016
Messages
29
I have a salary table that has four levels for an employee's workplace
salary3.png

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
salary.png

Any help?
 

Attachments

  • salary3.png
    salary3.png
    7.6 KB · Views: 78
  • salary.accdb
    736 KB · Views: 110

MajP

You've got your good things, and you've got mine.
Local time
Today, 16:10
Joined
May 21, 2018
Messages
8,527
Is this correct
format.jpg
 

Attachments

  • MajP_salary.accdb
    736 KB · Views: 85

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 04:10
Joined
May 7, 2009
Messages
19,242
see your report.
 

Attachments

  • salary.accdb
    848 KB · Views: 111

Pat Hartman

Super Moderator
Staff member
Local time
Today, 16:10
Joined
Feb 19, 2002
Messages
43,274
When two people offer different solutions, you might want to specify which you liked best.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 16:10
Joined
Feb 19, 2002
Messages
43,274
@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

New member
Local time
Today, 13:10
Joined
Sep 23, 2016
Messages
29
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

Super Moderator
Staff member
Local time
Today, 16:10
Joined
Feb 19, 2002
Messages
43,274
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:)
 

Users who are viewing this thread

Top Bottom