Flexible serial

[1aae]

Have good day..

Flexible serial

I there any way to make Flexible serial in a query without using primary key

If I have query with only empname and job

For example:

Serial empname job

1 a Dr

2 b eng

3 c dr

4 d MVP

5 e MVP

I want flexible serial when arrange empname ascending or descending the
serial stay as is (no change)

I hope you understand my question:

Note :

My query will not contain PK

I will arrange empname (ascending or descending)
thank you

 

[Van T. Dinh]

Not sure from the description but try:

http://www.lebans/rownumber.htm

 

[1aae]

thank you for your help
I have Find many code about how can you use serial with form and sub form
and query (rownumber.mdb)
but still i have the problem because when using the example in rownumber.mdb
in lebans code with query when sort desending the serial not work (begain
with big) form and sub serial is work start from 1 if you sort
(Ascending-Descending )
the expression:
Expr1: Serialize("query1";"code";

)
in this expresion related with field code when (code) sort Descending not
start with 1 start from the end
I hope you understand me
I need Flexible serial with query:

 

[Van T. Dinh]

I am not sure I undestood your question correctly and I haven't had any use
for the Serial Number for a while but you can try using the current Query
with the Serial Number to make a temporary Table. After that you can use
this temporary Table as the Source for new Query where you can sort
whichever way you want.