Grouping data in a report

[fallyhag]

I have MS Access set up to display all employees in a company.

I have a field called "Rank" which indicates their level of experience in the company.

Basically all I wanted to do was group all the "High", "Medium" and Low" employees together in a report, but all I seem to be able to do is sort them alphabetically.

I have searched the help files and experimented etc... but still no joy.

Any advice would be appreciated.

Thanks in advance

Fallyhag

 

[fallyhag]

In addition to the last question, how do I dictate which group comes first on the report?

Rather then have: (alphabetically)

High
Low
Medium

How do I get:

High
Medium
Low

 

[koresnordic]

Fallyhag,
Try this: Right click on the top left of the report (the part where you can access the reports properties). This will include an option for sorting and grouping. When you select this, you will be able to select the sorting criteria for the report, plus by looking in the lower half of the box, you will be able to say if this is to be grouped. You can select either a group header a footer or both. This will not put anything in these areas just create them. But you can put anything you like in them. Plus any total fields you put in the footer, will calculate just for that group.



Graham

 

[fallyhag]

Thanks, I will give it a go.

Fallyhag