R/LIST using BY-DSND (AREV Specific)
At 17 NOV 2000 03:24:44PM Deborah Donigian wrote:
I have a table of products with fields named SIZE, ITEM, PRICE and a SOLD_DATE field. When I try a R/List statement on the entire table BY ITEM BY SIZE BY-DSND SOLD_DATE I will get a list proper sorted by ITEM and SIZE but the SOLD_DATE field is not sorted right. If I sort the table only BY-DSND SOLD_DATE the rows are sorted in proper desending order by date. Any help with this would be appreciated.
At 18 NOV 2000 01:45AM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
Your query is a trifle ambiguous. Do you want it sorted in order of date sold, most recent first then broken down within date sold? If so the BY-DSND should come first.
If this is not the problem is there the chance that one of the other fields is multi-valued? This changes sort characteristics as it sorts one row per multi-value.
World Leaders in all things RevSoft
