arranging in particular order

[cliff]

Hi, mydata table is

sr nos (int+mod)
1 14 5
1 18 9
2 23 5
2 29 11
3 16 7
3 25 7

transa table is
(int+mod) ns
1 1
2 1
3 1
4 2
5 2
6 2
7 3
8 3
9 3
10 4
11 4
12 4
13 4

I want arrange/display nos in mydatatable in according to ns in transtable
like
nos
14
23
16
25
18
29

how to write to query to solve the problem

thanks million

cliff

 

[Al Campagna]

Cliff,
You could add another field to MyData table...

sr nos (int+mod) SortField
1 14 5 1
1 18 9 5
2 23 5 2
2 29 11 6
3 16 7 3
3 25 7 4

Sorting on SortField ascending will result in the order you specified.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."