hi,
everyboy, thanks for helping me time to time. Please once again i want some help from your end. the problem is I have a table with pk and another filed which i gave manul number from 1 to 488. But when i make a report then i want the report come according to asending number which i gave manually. But it does not come it come redumly.
like
1 harish
10 naresh
2 subhash
 it should come like
1 harish
2 subhas

thanking you,


from harish mankoti

It is very likely that the data type of the field is not numeric. It is a text sorting that you are showing. Are you storing more than just a number in that field? If not, change it to a numeric field. Otherwise, you can fake the numeric sorting by storing a 3 digit number: 001, 002, 003 ,004 and so on to to 488. Make sense?

Woody Z
http://www.learntoprogramnow.com