|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 6th, 2009, 07:28 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Sorting
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 
|
|
#2
February 6th, 2009, 07:58 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Sorting
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 "Bob76" wrote: 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
|
|
#3
February 6th, 2009, 05:56 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Sorting
On Thu, 5 Feb 2009 23:28:01 -0800, Bob76
wrote: 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? 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? -- John W. Vinson [MVP]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
