Re: Sorting in ACE, need help
Posted in 1997
Marco Greco (marcog@ctonline.it) wrote: :{ try :{ select part_no[1, 6], part_no[8,12], part_descr, part_price from stock :{ order by 2 If he needs the actuall part number itself for the report, he'd need to add it to the select: select part_no[1,6], part_no[8,12], part_no, part_descr, part_price from stock order by 2 -- gburnore@databasix.com mailto:gburnore@DataBasix.com ---------------------------------------------------------------------- How you look depends on where you go. ---------------------------------------------------------------------- Gary L. Burnore | DataBasix | 150 Haight Street Suite 507 | (Blank) San Francisco, CA 94102 | http://www.DataBasix.com | ======================================================================