Sorting

  • Thread starter Thread starter Bob76
  • Start date Start date
B

Bob76

Re: sorting.... I created a report from a one to many table, called Employee
Evaluation. it should look like this:

Empl# EmplName EvalDate Work Skills Attendance
Accountability
12 A, BC 12-Jan-08 4 5
3
12 31-Jul-08 3 5
3
12 2-Jan-09 3 4
4
25 D, EF 15-Jan-08 3 4
2
25 2-Aug-08 2 5
4
etc

I have another TbLMaster w/c shows all employees and this eval table is a
subdatasheet to this Master. In the report, it sorts by empl# okay, but when
I try to sort by EmplName, then by Empl#, then by EvalDate, to look like
above, all the blank emplName are grouped on top & all the records w/
EmplNames follow after all the blank ones. How do I do the sort so that it
will look like above?
Thanks, Bob
 
Oooops...my report got out of line....
Accountability should be the next column after Attendance.
Anyway... should be like this:
Empl# EmplName EvalDate WorkSkills Attendance Etc...
12 A, BC 12-Jan-08 4 5
12 31-Jul-08 3 5
12 2-Jan-09 3 5
25 D, EF 15-Jan-08 3 4
25 2-Aug-08 2 5
etc
 
I have another TbLMaster w/c shows all employees and this eval table is a
subdatasheet to this Master. In the report, it sorts by empl# okay, but when
I try to sort by EmplName, then by Empl#, then by EvalDate, to look like
above, all the blank emplName are grouped on top & all the records w/
EmplNames follow after all the blank ones. How do I do the sort so that it
will look like above?
Click to expand...

It all starts with the data! How are your tables structured? Could you post
the SQL view of the Query you're using as the basis of the report? Why do you
have blank employee names *at all* - shouldn't they just be in tblMaster, once
per employee?
 
Back
Top