How to get correct rooms (spaces) order in database worksheet?

[starling75]

I created report of rooms(spaces)but the spaces are in wrong order according to their space numbers ..

Does exist some simple solution how to get correct result?

room schedule.jpg

001

002

003

.... etc

Thanks

[Pat Stanford]

Select any row(s) in the database then drag one of the sort icons (the little "buttons" that look like bar charts) to the column that you want to sort by. One is Sort Ascending the other is Sort Descending. You can sort by up to three columns at once.

At least you have the leading zeros. Many people try to do this without them and can not get the proper sort.

[starling75]

Thanks, it works perfectly!