Special Grouping in a Report

[Aurora]

I am using Access 2003
I have a training Db which tells me, by employee, the machines they are
qualified to operate in different departments. The reporting I have done
before, is by Dept, with the machines from that dept listed across the top
and "all" employees listed on the left hand side in alpha order. There are
check boxes under each machine to indicate if the employee is trained on that
machine.

I have been asked to revise the report so that it lists (1) only the
employees within that department first then (2) list all other employees from
the plant.

In my query, under criteria, I put = "dept name" under the department and
got just the people within that department. Then I went to the next criteria
line and added <> "dept name". I thought this would group the employees from
within the department first and then group all other employees but this did
not work. Instead it list all employees as it had before. Can anyone
suggest a method to capture this information correctly. I suspect that I
need to develop two headers, but I do not know how to do this. Can anyone
help me, please.

Aurora

 

[NetworkTrade]

I believe that to accomplish this you will need to separate reports put
together using a subReport.

 

[Aurora]

What is a subreport? I have never heard of this before.
Aurora

 

[NetworkTrade]

Well one can not really teach Access per se via this forum - but SubReport is
an icon on your menu bar when in Report Design View.

You can have one Report for 'employees by department' and another Report
for 'employees NOT by department' and place this 2nd report into the first
via the SubReport method....

 

[Aurora]

I don't think you understand what I am trying to accomplish.
If I have 5 departments - lets call them dept 1, 2, 3 ect.
I want my report to list first all employees in dept. 3. Then under neith
that list all employees from all of the other departments - depts 1,2,4 &5.
In my query under the 1st criteria line and in the dept field I said "=dept
3". I get the employees from the dept 3 only. So then on the next criteria
line I put "<>dept 3" - and I get a blank answers. Which makes sense because
I am saying I want something and I am saying I do not the same thing. Are we
are the same page? Is there somewhere I can read about "subreports"?
Aurora

 

[John Spencer]

You should be able to accomplish this in the report using the report's
sorting and grouping dialog.
Assumption:
Your department field is named Dept
You haven't set any sorting and grouping for the report

In design view
-- Select View: Sorting and Grouping
-- In row1, column 1, enter: =Dept="Dept 3"
-- Set Sort Order to Ascending
-- Set Group Footer to "Yes"
-- In row 2, column 1, enter Dept
-- In row 3, column 1, enter EmployeeLastName (or whatever the field name
is)
-- Close Sorting and grouping.

If you don't want to have break between the sections, just sort by
Dept="Dept3" and don't set the group footer to yes.

 

[Aurora]

Thank you and all of you who tried to help me.
I finally figured out that what you are saying and did it.
My report works great now.

Again Thanks to everyone who offered help.

Aurora