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.

--
HTH
Van T. Dinh
MVP (Access)



"Marco" <marco.w-no-spam-(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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
>
>
>

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



"Van T. Dinh" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>
> --
> HTH
> Van T. Dinh
> MVP (Access)
>
>
>
> "Marco" <marco.w-no-spam-(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> >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
> >
> >
> >
>
>

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

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

--
HTH
Van T. Dinh
MVP (Access)



"Marco" <marco.w no spam @email.it> wrote in message
news:(E-Mail Removed)...
> How can I add the number ? I have 90000 records in table and now the name
> are random.
>

"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 ...
>
> --
> HTH
> Van T. Dinh
> MVP (Access)
>
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 ...

--
HTH
Van T. Dinh
MVP (Access)



"Marco" <marco.w-no-spam-(E-Mail Removed)> wrote in message
news:Oa%23Ypp%(E-Mail Removed)...
>
> 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 .
>