Report Sorting

[kucherls]

I have a report based on a query.A Column called PRIORITY which sorts
in alpahbetical order when i make it either ascending or descending.
Project Mgmt Priority
Critical
Critical
Critical
Medium
Critical
Medium
Low
Critical
Critical
Low
Low
Low
Low
Critical
Critical
Low
Medium
Low
Critical
Low
Low
Low
Low
What i would want to do is sort it in another way,like
Critical,High,medium,Low.
I also have a priority table which has these columns called
Name(Critical,High,medium,Low) and sort order column 1,2,3,4 and i want
to use that sort order in my query.So how do i actually join that table
to my existing query and how can i apply that sort to my Proj Mgmt
Priority column.

Thanks
Srikanth

 

[Duane Hookom]

Add the "priority table" to your report's record source query while in
design view of the query. Join the appropriate fields and add the unnamed
"sort order column" to the grid. You can then use this field in your
report's sorting and grouping.