sort

S

Steiner

All I need to do is sort my prducts in a particulasr order. I dont want to
use assending or descending. For example i have a country list

UK T
UK T ( represent different columns)
UK L
Germany T
Germany T
Germany L
etc....... I need to keep this order. The problem is that I have other
colunms such as year and other subcategories, so when i change one colunm and
make it look how i want the year column for example will be all mixed up
How can I fix this problem........ please help. Thank you very much in
advance, help will greatly e appriaciated
laurent
 
P

peregenem

Steiner said:
All I need to do is sort my prducts in a particulasr order. I dont want to
use assending or descending. For example i have a country list

UK T
UK T ( represent different columns)
UK L
Germany T
Germany T
Germany L
etc....... I need to keep this order.
Click to expand...

SELECT country_name, TorL
FROM MyTable
ORDER BY
INSTR(1, 'UK Germany', country_name) \ 7,
INSTR(1, 'TL', TorL)
 
S

Steiner

Iam sorry i am new to access, can you explain what this means and where i am
supposed to implement it . Thank you so much.
 
S

Steiner

I want to have

Steiner said:
Iam sorry i am new to access, can you explain what this means and where i am
supposed to implement it . Thank you so much.

:
Click to expand...
For example i would want T
A
L
really need to figure this out of a report

 
A

Avlan

Put it in the rowsource property of the dropdown list.

Lets clear things up: There is no 'order' in table. You have it sorted
on your screen maybe, but technically it has no order. If you want to
show, say, 3 colums from the SAME table but sorted DIFFERENTLY, you
need to make 3 dropdown-boxes (or whatever you want) with a SQL
statement in the properties RowSource of these dropdowns.

the Rowsource property of a box tells the box which data to select from
which table and to show it there. Select the box in the design view of
your form, right-click and select properties, and find 'RowSource'.
There you place the SQL statement.

For basic SQL tutorial, check out www.w3schools.com
 
S

Steiner

Thank you ver much what u said was great help, however do I have to write an
SQL just to sort certain prducts in a particular way In other words
having
T A
A L
L T
instead of
thank you again
 
P

peregenem

Steiner said:
do I have to write an
SQL just to sort certain prducts in a particular way
Click to expand...

SQL is the language of databases. Either you, someone else or a machine
must write it. Which do you want it to be? :)
 
Top