How To sort

  • Thread starter Thread starter ياسر
  • Start date Start date
Ù

ياسر

How to Sort Names in the reports or forms By there Job Titles :
For example:
If you have some Employees in dept and they Have a Manager and Project
Director and then the Seniors
etc...
So how to Sort the Employees names By there Job Titles in the or report for
each department Not alphabetic like the following table :-
Department Name-------------------------------
____________________________________________
emp Name Job Title Salary etc
____________________________________________
yasser Manager 1000 ------
Admen Project Director 900 -----
------- Coordinator ---- ---
etc..
Using access 2003
 
So how to Sort the Employees names By there Job Titles in the or report for
each department Not alphabetic like the following table :-
Department Name-------------------------------
____________________________________________
emp Name Job Title Salary etc
____________________________________________
yasser Manager 1000 ------
Admen Project Director 900 -----
------- Coordinator ---- ---
Click to expand...

Please explain what you mean. You say "sort by there [sic] Job Titles" but you
also say "Not alphabetic". If you don't want them sorted alphabetically how DO
you want them sorted?
 
John W. Vinson said:
So how to Sort the Employees names By there Job Titles in the or report for
each department Not alphabetic like the following table :-
Department Name-------------------------------
____________________________________________
emp Name Job Title Salary etc
____________________________________________
yasser Manager 1000 ------
Admen Project Director 900 -----
------- Coordinator ---- ---
Click to expand...

Please explain what you mean. You say "sort by there [sic] Job Titles" but you
also say "Not alphabetic". If you don't want them sorted alphabetically how DO
you want them sorted?
Click to expand...
fist will be the manager name
then the directors names then
the coordinators names
so not will be sorted as the default sorting do
ascending or desending
i need to sort them by the sequence i wrote .
Not by names as alphabetical A to Z or not by titles as a;alphabetical also
Did u understand what i means ?
thank you
 
John W. Vinson said:
So how to Sort the Employees names By there Job Titles in the or report for
each department Not alphabetic like the following table :-
Department Name-------------------------------
____________________________________________
emp Name Job Title Salary etc
____________________________________________
yasser Manager 1000 ------
Admen Project Director 900 -----
------- Coordinator ---- ---
Click to expand...

Please explain what you mean. You say "sort by there [sic] Job Titles" but you
also say "Not alphabetic". If you don't want them sorted alphabetically how DO
you want them sorted?
Click to expand...
fist will be the manager name
then the directors names then
the coordinators names
so not will be sorted as the default sorting do
ascending or desending
i need to sort them by the sequence i wrote .
Not by names as alphabetical A to Z or not by titles as a;alphabetical also
Did u understand what i means ?
thank you
Click to expand...

You should consider using a table of Job Titles with two fields - JobTitle and
SortOrder. This might have records like

Manager; 10
Project Director; 20
Coordinator; 30

Include this table in the Query for your report, and sort by the SortOrder
field.

I'm using 10/20/30 rather than 1/2/3 so that it will be easier in the future
to add a new title in the middle of the sequence (Associate Director; 25)
 
Back
Top