sort by letter not in ascending or descending

[Kelly]

Hi,

I have a problem. My access 2003 database has a "Status" field. Status
contains letter F (faculty), S (support), E (emeriti), and A (academic).
I would like to do a print report where sort of group of F (faculty) will be
first , second group is E, third group is A and last group is S

Please help...thank you.

 

[KARL DEWEY]

Build a Sort/Translation table with two fields --
Status Sort
F 1
S 2
E 3
A 4
Join this table in your query that is record source for the report. Select
the Sort field in the report Sorting And Grouping.

 

[Duane Hookom]

I like Karl's solution since the sort order is determined by data.
However, a less attractive alternative is to set the sorting and grouping
expression to something like:
=Instr("FEAS",[Status])
If you ever want to change the sorting, you would have to change this in the
report design view. Karl's solution provides the flexibility of changing the
sort order by changing values in data.