[AccessD] Tilde Sort at the top

Mark:

I don't care what advice you send me.  It's nice to hear from you for any reason.  How's the little cowgirl?

I did discuss with my client the possibility of using a lower case z for those items on which we were using the tilde.  But Lambert's solution works perfectly well if I implement it correctly.  Which I did after a few tries.  So the tildes sort to the bottom of the list and all's well in Del Mar.  For the moment.

Best,

Rocky

  ----- Original Message ----- 
  From: Mark L. Breen 
  To: Access Developers discussion and problem solving 
  Sent: Thursday, July 31, 2003 12:21 AM
  Subject: Re: [AccessD] Tilde Sort at the top


  Hello Rocky,

  I have just thought about it and without getting complicated and using two columns in the recordsource to specify the sort order I cannot see a simple way to get tilde to go to the top of your ascending list.

  I presume that you are concatenating on the tilde as in

  Mark Breen
  John Colby
  ~Rocky Smolin

  Could you just replace the tilde with Z~ or if your really need it, ZZ~

  If they are at the bottom and out of alphabetic order anyway, I guess that they are some sort miscellaneous items, perhaps the Z will not matter.  If you need to later display the names you could use a Right(fieldname, 2)

  I know that I am teaching my granny to suck eggs, but just in case.

  Otherwise, hello to you,

  Mark

    ----- Original Message ----- 
    From: Rocky Smolin - Beach Access Software 
    To: AccessD at databaseadvisors.com 
    Sent: Wednesday, July 30, 2003 6:57 PM
    Subject: [AccessD] Tilde Sort at the top


    Dear List:

    I need a special character to sort the contents of a combo box so that items with the special character sort at the bottom of the list.  (The items come from a table).  So I tried using a tilde ~ because its ASCII value is 126, greater than any number or upper or lower case letter.  But it sorts to the top of the list.

    Is there a simple explanation and/or workaround?

    Much thanks in advance and regards,

    is



----------------------------------------------------------------------------


    _______________________________________________
    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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030731/8002234c/attachment-0001.html>