Ms Access And Ms Excel – What To Do When Sorting Does Not Work
In both Microsoft Access and Microsoft Excel it is very easy to sort columns of text or numbers. Both programs supply us with toolbar buttons that allow either ascending sorts (1 … 999) or descending sorts (999 … 1). The Ascending button has a blue “A” above a red “Z” with a downward pointing arrow to the right of the 2 letters. The Descending button has a red “Z” above a blue “A” with a downward pointing arrow to the right of the 2 letters. Simply put the cursor in the column you want sorted and click once on the appropriate button.
As I stated in that first paragraph, this works great for text or numbers. The challenges start when you want to sort mixed text and numbers. Here are 2 simple real life examples. (NOTE: the remainder of this article assumes we want ASCENDING sort order)
Example 1: Part Numbers. On a computer, which comes first?
– W4
– W39
– W212
Example 2: Addresses. On a computer, which comes first?
– 4 Main Street
– 39 Main Street
–...
To view and download this full PLR article, you must be logged in. Registration is completely free. Once you create your account, you will be able to browse, search & downlod from our PLR articles database of over "1,57,897+" on 1,000's of niches and 200+ categories without paying a penny. Click here to signup...
