Oleg_123 at xuppa.com
Oleg_123 at xuppa.com
Tue Oct 21 10:05:21 CDT 2003
then just try what Gustave sent --- SELECT TT.r FROM TT ORDER BY StrComp(r, Cstr(Val(r)), 1), r; > The problem with using Excel is getting it in there in the first place. > Excel apparently knows better than I what I want:( On pasting as Text, > it automatically does the conversion back to numeric. With 46,655 > records I would prefer not to do any manual editing such as formatting > with a " ' " or changing entries like 7000000000 back to 7E9. The > Access table I have has all the data already in the correct format...I > was hoping for an SQL sorting solution. I'm just frustrated with my > lack of vision on this particular problem. > > > > Mark > > > -----Original Message----- > From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com] > Sent: Tuesday, October 21, 2003 10:40 AM > To: accessd at databaseadvisors.com > Subject: RE: [AccessD] Sorting Alpha-Numerics > > > Mark, I just tried it Excel also, if u want t do it there, make sure you > format into text first (from general) > >> Mark, >> >> I believe that Excel converts 7E9 to 7 * 10 to the 9th power. >> >> Try putting a single apostrophe in front of the AAA. In the formula >> bar it will look like 'AAA, but in the cell it will look like AAA. >> This tells Excel that you want the cell contents treated like text, >> and should prevent the conversion to an exponential value. >> >> Dan Waters >> Quality Process Solutions >> >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mitsules, >> Mark Sent: Tuesday, October 21, 2003 8:59 AM >> To: '[AccessD]' >> Subject: [AccessD] Sorting Alpha-Numerics >> >> >> Greetings, >> >> I have a text field containing all possible 3 digit alpha-numeric >> combinations from 000 to ZZZ. I am looking for a method to sort this >> text field where 000 through 999 are listed in numerical order before >> the remaining alpha-numeric combinations are listed in ASCII sort >> order. Any suggestions? I have tried to do this in Excel, however, >> Excel makes some startling decisions on its own...such as turning 7E9 >> into 7000000000. >> >> Example: >> 000 >> 001 >> . >> . >> 998 >> 999 >> 00A >> 00B >> . >> . >> ZZZ >> >> >> Mark Mitsules >> Senior Designer >> Department E13 >> Submarine Electrical Engineering >> Northrop Grumman Newport News >> 757.380.3376 >> _______________________________________________ >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> >> >> _______________________________________________ >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com > > > > ----------------------------------------- > Get Breaking News from CNN, ABC, NBC, CBS Now. > http://www.xuppa.com/news/?link=webmail > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com ----------------------------------------- Get Breaking News from CNN, ABC, NBC, CBS Now. http://www.xuppa.com/news/?link=webmail