First of all, I’m so sorry about my english. I hope somebody could understand what I am talking about.
Here is my question : how can do a field-sorting in the word instead of DB?
I have a table named test_sort in database, all of its columns are :
id varchar(32) pk,
I want to display all records of table test_sort in Microsoft Word and sort them order by increasing.
We could use sql script:
select username, age, birthday, company_name from test_sort order by username, age, birthday, company_name asc
But some other day, boss need me to display these records order by username increasing, age increasing and birthday decreasing, company_name decreasing.
So I have to change these sql script like:
select username, age, birthday, company_name from test_sort order by username asc, age asc, birthday desc, company_name desc
And another day, boss has new requirement, and I have to change these sql script agian and agian.
So I think whether I could do the sort in Microsoft Word indtead of database, just like add or edit a mail merge field?