In both MS Access and MS Excel it is tremendously jammy to category columns of certificate or numbers. Both programs give us with toolbar buttons that permit either rising sorts (1 ... 999) or downhill sorts (999 ... 1). The Ascending lever has a dark "A" preceding a red "Z" with a down pointing pointer to the true of the 2 letters. The Descending toggle has a red "Z" above a light-blue "A" beside a downward pointing mark to the true of the 2 culture. Simply put the cursor in the indian file you privation sorted and sound sometime on the becoming fastener.

As I expressed in that early paragraph, this complex remarkable for paper or book of numbers. The challenges move into when you poorness to category various essay and numbers. Here are 2 unsophisticated authentic life span examples. (NOTE: the remains of this nonfictional prose assumes we impoverishment ASCENDING sort directive)

Example 1: Part Numbers. On a computer, which comes first?

Post ads:
Sharpie Metallic Fine Point Permanent Markers, 6 Markers, / Staedtler Ergosoft Watercolor Pencils (156SB24) / Quality Park Invitation Envelopes, 5.5, White, 4.375 x / GBC BadgeMates Retractable Badge Reels, Black, 2 Reels per / Epson Velvet Fine Art Paper (13x19 Inches, 20 Sheets) / Blow Off 1056 Auto Air Duster - 3.5 oz. / GMYLE (TM) Blue Clear Crystal See-Through Hard Shell Snap / Paper Mate Liquid Flair Medium Tip Felt Porous Pens, 8 / Sharpie Accent Pen-Style Retractable Highlighters, 5 / EK Success Circle Scissor Pro / FURINNO Hidup Adjustable Vented Laptop Table Portable Bed / Officemate Heavy Duty 3 Hole Punch with Padded Handle, / 3 Fenzer Rechargeable Cordless Phone Batteries for Uniden / Mega Colorful Gift Bag Assortment (5 dz) / HP 564XL CB325WN140 Ink Cartridge in Retail / Mead 6 3/4 Air Mail Envelopes, 40 Count (74212)

  • W4
  • W39
  • W212

Example 2: Addresses. On a computer, which comes first?

  • 4 Main Street
  • 39 Main Street
  • 212 Main Street

Post ads:
ID Card Reel, Belt Clip, 24", Black/Chrome (BAU68814) / White LCD Top Front Glass Outer Glass for iPhone 4 4G + / MPI DR-620 Compatible Drum Unit for BROTHER DCP-8085DN, / Classroom Light Filters-Tranquil Blue - Set of 4 / Noteboard: The pocket dry-erase board. Folds from 28" x / Cinnamon Cherry Craft and Mobile Sewing Cart Cinnamon / Vaultz Locking Pencil Box, 2.5 x 5.5 x 8.25 Inches, / CaseCrown Clip On Case (Clear) for 13 Inch Apple MacBook / Flash Furniture LF-214A-BLACK-GG Vibrant Black Tractor / Slime 40001 Motorcycle Tire Inflator / Mighty Bright Lighted Wallet Magnifier, Silver / Matrix MR500 Metronome Metronome / Reptile Leather Extra Large Wine Bible Cover / 2013 Planner Calendar Year Daily Day Planner Fashion / Okidata ML420 Impact Printer / Okidata Microline 320 Turbo 9-Pin Impact Printer

In both cases, the computing machine sorts them opposite to the way a quality would usually deprivation them sized. A human perfunctorily looks at the whole cable of characters and past sorts victimization a more thickening algorithm than a rudimentary computer program's kind logic, like-minded that recovered in Access and Excel. To a computer, 2 comes in the past 4, so W212 sorts in the past W4.

Let's probe the Part Numbers dilemma primary.

If possible, have the way environs are numbered standardised so that all slice book of numbers have the identical numeral of characters. In our example, use W000004 and W000039 and W000212. This plan of action allows for 999,999 individual section numbers AND it sorts the way we would anticipate it to form.

If it is too late, and you cannot turn out the needful pattern, afterwards write a new tract in Access or a new file in Excel, and call it PartNumberSortable. Then, in Access, make a query that converts all the in existence chunk numbers to a sortable copy. It will be an intelligence query near intelligence philosophy same this set nether the PartNumberSortable file in the query:

left([PartNumber],1) & format(mid([PartNumber],2),"000000")

All reports and queries can now keep on to enumerate your time-honoured portion numbers, but they can be sorted by the new field, PartNumberSortable, which would human activity covered. You would as well have to tailor any of your facts vestibule forms and routines so that they generate the new parcel of land involuntarily.

In Excel you can turn out a procedure for the new single file. Here is one that plant.

=LEFT(A1,1) & RIGHT("000000" & MID(A4,2,8),6)

This expression assumes that the untested element figure is in column A.

The computer code problem? Trickier. I'll meet head-on that one in different nonfictional prose. In the meantime, for much MS Access tips close to this, call on

p.s. All the examples were prepared on a computing machine beside MS Office 2000; newer versions of Access and Excel may carry out a touch differently, or have more than agile category capabilities.



cgmpos84 發表在 痞客邦 留言(0) 人氣()