<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4916.2300" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=276540318-30072003><FONT face=Arial color=#0000ff
size=2>Rocky,</FONT></SPAN></DIV>
<DIV><SPAN class=276540318-30072003><FONT face=Arial color=#0000ff size=2>How
about just specifying the special condition in your order by
criteria?</FONT></SPAN></DIV>
<DIV><SPAN class=276540318-30072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=276540318-30072003><FONT face=Arial color=#0000ff size=2>For
example:</FONT></SPAN></DIV>
<DIV><SPAN class=276540318-30072003><FONT face=Arial color=#0000ff size=2>SELECT
Customer.CustomerName</FONT></SPAN></DIV>
<DIV><SPAN class=276540318-30072003><FONT face=Arial color=#0000ff size=2>FROM
Customer</FONT></SPAN></DIV>
<DIV><SPAN class=276540318-30072003><FONT face=Arial color=#0000ff size=2>ORDER
BY (Customer.Status = "Active"),</FONT></SPAN></DIV>
<DIV><SPAN class=276540318-30072003><FONT face=Arial color=#0000ff
size=2>Customer.CustomerName.</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Rocky Smolin - Beach Access
Software [mailto:bchacc@san.rr.com]<BR><B>Sent:</B> Wednesday, July 30, 2003
12:57 PM<BR><B>To:</B> AccessD@databaseadvisors.com<BR><B>Subject:</B>
[AccessD] Tilde Sort at the top<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Dear List:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Is there a simple explanation and/or
workaround?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Much thanks in advance and regards,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>is</FONT></DIV>
<DIV> </DIV></BLOCKQUOTE><br><br>--------------------------------------------------------------------------------------------------------------------<br>This email and any files transmitted with it are confidential and<br>intended solely for the use of the individual or entity to whom<br>they are addressed.<br>If you have received this email in error please notify the<br>originator of the message. This footer also confirms that this<br>email message has been scanned for the presence of computer viruses.<br><br>Any views expressed in this message are those of the individual<br>sender, except where the sender specifies and with authority,<br>states them to be the views of Tappe Construction Co.<br><br>Scanning of this message and addition of this footer is performed<br>by SurfControl E-mail Filter software in conjunction with <br>virus detection software.<br></BODY></HTML>