[AccessD] ASCII Sorting - Numeric First, then Alpha-Numeric

Well now...wouldn't that just be too simple? ;)

Thanks...over analysis strikes again.

Mark


-----Original Message-----
From: Brock, Christian (Internet) [mailto:christian.brock at hoffman.army.mil] 
Sent: Monday, August 11, 2003 4:46 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] ASCII Sorting - Numeric First, then Alpha-Numeric


Add another long integer column to the table that specifies the sort order
and sort using that column.

Christian Brock

-----Original Message-----
From: Mitsules, Mark [mailto:Mark.Mitsules at ngc.com] 
Sent: Monday, 11 August 2003 15:31
To: '[AccessD]'
Subject: [AccessD] ASCII Sorting - Numeric First, then Alpha-Numeric
Importance: High


Group,

I am converting an Excel solution to Access.  The Excel solution had a
column of values that the user typed in (numerical sequence as text
000-999).  I have created a table of all possible 3 character codes (46,656
records).  I would like a list box to default to the next available code. As
the Excel list is already at 919, I would like the remaining numeric codes
to be used first (920-999), after that, ASCII sort is fine .  Any thoughts
on how I can accomplish this?


Mark
_______________________________________________
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