custom list in field

  • Thread starter Thread starter Marco
  • Start date Start date
M

Marco

I have a text field in a table and i need have a costum order.
Is it possible; with a query too?
ex
blue
orange
green
red
yellow
orange
red
blue
yellow
green

i need:
yellow
red
blue
green
orange
yellow
red
blue
green
orange

thx a lot
 
Create an extra Field "SortNo" (Integer or Byte) in your Table and allocate
a number according to your sorting requirements.

In the Query simply sort the records / rows by the SortNo.
 
I am not sure of your sorting algorithm now ...

Define them in words and them give more representative sample of actual data
....
 
"Van T. Dinh" wrote
I am not sure of your sorting algorithm now ...

Define them in words and them give more representative sample of actual
data ...
Click to expand...
My table is
ID, datefield, textfield, (field1, field2, fiel3) number
textfield are colors, they are 11
I desire to have-see the color in a precise order like a list.
Now i can order by date but the colors aren't always in same order.
I need to define a "range " = colors and to repeat it for all the records of
the table .
 
Sorry, I can't think of any way Access can do this type of sorting ...

OTOH, you may have to think of cases where you don't have equal number of
records for each colour, e.g. 80K records have Yellow and random numbers for
other colours ...
 
Back
Top