Report order

  • Thread starter Thread starter Eva
  • Start date Start date
E

Eva

Hi
I created report with header sorted out descending. Management asked me to
change the order to specific items, so can I do it without many changes to
the querries or report? I was thinking about putting numbers like
1-Itemx,2-Itemy etc., but it doesn't look nice. Any suggestions?
 
The simplest way to sort items in a non-alpha order is to have a table with
the value you see and another column MySortOrder (Currency). Then you can
enter values in that field to specify your sort order.

Using currency or non-integer numbers allows you to add new values and insert
them into the sort order without re-setting lots of sort order values.

FieldItem FieldSort
AA ________ 1
XZ ________ 2
Y ________ 3
ABC ________ 4

Add a new item JKL and sort it into third position
JKL ________ 2.5

Add another item KZX and sort it into third position and move everything else
down.
KZX ________ 2.25

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Or using a numbering system that leaves room for insertions. (Remember the
old BASIC line numbering)
10, 20, 40, 50, etc
 
Back
Top