Sort Order - What's After Z?
Posted on 1999-07-28
On the report for access 97, I am trying to sort a field in ascending order. One of the records in that fields is called ANY that I need to show at the very bottom of all other records for that field. When I apply sort, of course ANY pops up at the top with A's. I tried to use ASCII characters with ANY like *ANY or _ANY but they didn't seem to make any difference - in fact they made *ANY or _ANY appear at the top (not at the bottom after Z's) How can I make ANY appear after Z's at the bottom? Is there an ASCII character that I could tag on to the front of ANY that will allow me to do that?