[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== R/LIST using BY-DSND  (AREV Specific) ====
=== At 17 NOV 2000 03:24:44PM Deborah Donigian wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
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.
</QUOTE>
----

=== 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:  ===

<QUOTE>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.



[url=http://www.sprezzatura.com" ]The Sprezzatura Group[/url] 

[i]World Leaders in all things RevSoft[/i] 

[img]http://www.sprezzatura.com/zz.gif[/img] 

 

 

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=8D1EC989D6788A028525699A00702100|View this thread on the  forum...]]