Search results for query: *

Thanks WildHare!!! What I did was: Create a second field that striped the number out using the "val" function, Sort = Ascending (this is placed before the original field in SQL syntax) Then I sorted the original field ascending and ... all is well in the world!!! Many Thanks Bill...

Hello all! I am trying to sort an alpha-numeric field in my reports with poor results. The data is similar to an outline format (1, 1A, 2, 2A, ... , 10, 10A, ... up to 50). Access returns (1, 1A, 10, 10A, 11, ... , 2, 2A ... and so on). I would appreciate any help in this matter.

Emailed!

well, i was wondering if i could email you the script so you could see the entire code or, do you want to talk on yahoo messenger or somthing ?

thats how i did it: <FORM NAME=&quot;script&quot; ACTION=&quot;script.cgi&quot; METHOD=&quot;POST&quot;> <INPUT TYPE=&quot;HIDDEN&quot; NAME=&quot;action&quot; VALUE=&quot;send&quot;> TABLE WITH FORM FIELDS </form> and it still does the same thing

heres what the form tags are: <FORM NAME=&quot;script&quot; ACTION=&quot;script.cgi&quot; METHOD=&quot;POST&quot;> <INPUT TYPE=&quot;HIDDEN&quot; NAME=&quot;action&quot; VALUE=&quot;send&quot;>

i did it and i get the same errors here i'll show more of my code: #!/usr/bin/perl -w use CGI; #loads cgi.pm. use CGI qw(:all); print header; ###################################################################### # EDIT THESE VARIABLES BELOW...