How to

  • Thread starter Thread starter Zahid
  • Start date Start date
Z

Zahid

How can I in MS ACCESS, in certain report if I want to get the result, not
in ascending order, or decending order I Want that Name of

Managing director
Director
Director IT
Director Supply
Sales Representative
Cashier

In sequence Given up. How can achieve this?
 
If you don't already have a "Positions" table, create one. Then, in
addition to the PositionName field create a field called "PositionOrder" or
Hierarchy Join this table to your report query but sort/group on the new
Hierarchy field.

You should establish referential integrity between tables to make sure that
the values in the Positions table are the only values allowable in the
Position field in Employees (or wherever they are). If you don't, your
report will be missing data or very confusing depending on how the tables
are joined in the query.

Hope this helps,
 
How can I in MS ACCESS, in certain report if I want to get the result, not
in ascending order, or decending order I Want that Name of

Managing director
Director
Director IT
Director Supply
Sales Representative
Cashier

In sequence Given up. How can achieve this?
Click to expand...

One way is to have a calculated field in your Query:

SortKey: Choose([Fieldname] = "Managing director", 1,
[Fieldname] = "Director", 2,
[Fieldname] = "Director IT", 3,
....

and so on, where Fieldname is the name of the field containing the
position name. Sort by this calculated field.
 
Back
Top