Sorting of numeric filed’s values is needed 2

[katrina11]

Hi experts!

I have an existing data entry application implemented in Access 2007. Whenever user selects a memberOrder , he can enter data.
The problem is that memberOrder is not sorted . Or rather sorting is not customized.
Whenever user click on memberOrder field heading, system provide a filters box where it is filtered in the following way:
1
10
11
12
13
14
15
16
17
18
19
2
20
And so on...
I found a query which is responsible for the Form but I do not know how to change it so that if give MemberOrder in the common way:
1
2
3
4
I assume "Order By" clause is needed in SQL view. However, when I added “order by memberOrder” it has no effect.

I wonder what syntax would implement what I am looking for. Could you please help me to fix that?

Thank you!

Katrin

 

[PHV]

Use an ORDER BY clause in the query selecting records from your new [2a_Members for Chart Review] table.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Andrzejek]

Records in any table in any data base are kept without any particular order. It may *seam* that you may have records in order if you look at the table without specifying the order, but you need to always order them when you request info from any table(s) if you need to have them ordered.

Have fun.

---- Andy

 

[katrina11]

HURRAY! I finally got upon PHV directions!

Thank everybody who helped me.