Make order in a group

[mymy]

I have A report that have 5 fields. When the five fields have the same value..they make a group..But when one value of the 5 field is not the same, it change the group. Everything is okay for that.
In one of these field it have 4 possibilities. And I would like to display it in the order that I want..I don't want the alphabetic order. I want my own order.

Any help would be appreciated.
Myriam

 

[Chris RR]

Hmmm, that there is obviously some characteristic about your data that you want to bring into this sort. Your custom order isn't random, right? You know what it should be...

Remember that you can sort by a field that you never print. And you can create fields in your query that you can use to sort (but never see again.)

Maybe you need to just add a temp field to help you group in your query. For example, if you have 159 categories of product, and want to group all the raw fruit separately from the 158 types of processed fruit, create a new field in the query. Set up an "IF" to give this a value of "R" for the one raw fruit category, "P" for everything else. Then include this field in your sort, but not in your print.

Otherwise, the classic sneaky programmer method is to resort to storing a separate sort key. Again, you are just putting information into the query that you yourself already know.

You can either add a new field to your table, or create a little lookup table. Then put some sort of value into this field that will give you the sort you need.


[This message has been edited by Chris RR (edited 08-07-2001).]

 

[Pat Hartman]

This question has already been asked and answered. Please don't repeat the same (or reworded) question. If you don't understand the answer given, ask for clarification.