Outputting records into a specific order not numerical or alphabetical

[sue]

I have a report that is grouped by a Site. Each site has
a number of records underneath it. These records are
coded W/W , I/O, F/V also W/W M F/V M And W/W T F/V T.
I need to apply a specific order to the output as follows:

W/W, I/O F/V

and W/W M, F/V M, W/W T, F/V T

Thanks for you help in advance.

Sue

 

[Duane Hookom]

Why did you divide your sample data into separate groups? Is this
significant? In other words, why do you list some values and then use " also
" and then use " and ".

If these were color values and you wanted to sort them in a particular
order, the best method would be to create a lookup table of colors with the
order you want them sorted stored in a field in the table
tblColors
==========
Green 3
Blue 1
Red 5
White 4
Orange 2
A hard coded method is to set the sorting to an expression
=Instr("Blue,Orange,Green,White,Red", [ColorField])