custom list in field

[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

 

[Van T. Dinh]

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.

 

[Marco]

How can I add the number ? I have 90000 records in table and now the name
are random.

 

[Van T. Dinh]

I am not sure of your sorting algorithm now ...

Define them in words and them give more representative sample of actual data
....

 

[Marco]

"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 ...

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 .

 

[Van T. Dinh]

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 ...