Outputting records into a specific order not numerical or alphabetical

  • Thread starter Thread starter sue
  • Start date Start date
S

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
 
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])
 
Back
Top