Report order

[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?

 

[Gina Whipp]

Eva,

In the Reports design view, look at Sortings and Groupings (it's a button on
the Menu Bar), this sounds like it will give you waht you need without
changing the the Report or the query.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[John Spencer]

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

 

[KARL DEWEY]

You can sort on something without displaying it.

 

[Klatuu]

Or using a numbering system that leaves room for insertions. (Remember the
old BASIC line numbering)
10, 20, 40, 50, etc

 

[Eva]

Thank you. I did it and it works fine

 

[Eva]

Thank you John
I created a table with my sorring instructions and it works fine. Thank you

 

[Gina Whipp]

You're welcome!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm