sort but not by A to Z

[Steve]

Hi
Is there any way I can sort data in a report other than
assending or desending. We have priority system that
user the letter D, P and C. D=Highest priority, P=Middle
and C lowest. I would like to sort my report to display
in this order. Any ideas? (The letters are set in
stone - I cant change to ABC - unfortunatly)

cheers Steve

 

[Allen Browne]

Create a lookup table for these values, with fields:
PriorityID Number (Long) Primary key
Priority Text (1)

Entries will be:
1 D
2 P
3 C

Include this table in the query for the report.
Now specify PriorityID in the report's Sorting and Grouping box.