How to sort in ascending and descending order

Hi ,

I have a field in which i use formula to display the name of all user

temp:=@DbColumn(“”:“”;“”:“names.nsf”;“(viefullname)”;2);

@Trim(“Select”:@If(@IsError(temp);“”;temp))

but it comes in a unsorted order , i want to sort the name for that what i have to add more in my formula

Subject: How to sort in ascending and descending order

hi, try this

temp:=@sort(@DbColumn(“”:“”;“”:“names.nsf”;“(viefullname)”;2);[ASCENDING]);

@Trim(“Select”:@If(@IsError(temp);“”;temp))

“have a nice weekend” :slight_smile:

Subject: RE: How to sort in ascending and descending order

Thanks Yaar …Hey Anand plz look into my previous query