<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<pre wrap=""><span class="moz-txt-citetags"></span><!---->
Kenneth Brody wrote:
</pre>
<blockquote type="cite">
<pre wrap=""><span class="moz-txt-citetags">></span>Quoting Boaz Bezborodko (Tue, 19 Sep 2006 14:46:29 -0400):
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">> </span>
<span class="moz-txt-citetags">></span>
</pre>
<blockquote type="cite">
<pre wrap=""><span class="moz-txt-citetags">>></span>Kenneth Brody wrote:
<span class="moz-txt-citetags">>> </span>
<span class="moz-txt-citetags">>></span>
</pre>
</blockquote>
<pre wrap=""><span class="moz-txt-citetags">></span>[...]
<span class="moz-txt-citetags">> </span>
<span class="moz-txt-citetags">></span>
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap=""><span class="moz-txt-citetags">>>></span>Add a minor sort on A1 (or A7 or any of the A group) and place A1 and
<span class="moz-txt-citetags">>>></span>A7 on the report. They will now refer to the corresponding entry in
<span class="moz-txt-citetags">>>></span>the record.
<span class="moz-txt-citetags">>>></span>
<span class="moz-txt-citetags">>>> </span>
<span class="moz-txt-citetags">>>></span>
</pre>
</blockquote>
<pre wrap=""><span class="moz-txt-citetags">>></span>But what if A1 has is blank and A7 has an entry. This might happen if a
<span class="moz-txt-citetags">>></span>check pays off one invoice, but references 3 deductions. Will only the
<span class="moz-txt-citetags">>></span>A1 with an entry print leaving the other A7s out of the report?
<span class="moz-txt-citetags">>> </span>
<span class="moz-txt-citetags">>></span>
</pre>
</blockquote>
<pre wrap=""><span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">></span>Correct. If you sort by A1, then only the non-blank A1's (or just
<span class="moz-txt-citetags">></span>the first, if all are blank) will be included. Also, from this
<span class="moz-txt-citetags">></span>description, I take it that order is significant? In that case,
<span class="moz-txt-citetags">></span>this wouldn't work, anyway, as you would get them in sorted order,
<span class="moz-txt-citetags">></span>and not the order in which they appear in the record.
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">></span>--
<span class="moz-txt-citetags">></span>KenBrody at BestWeb dot net spamtrap: <a
class="moz-txt-link-rfc2396E" href="mailto:g8ymh8uf001@sneakemail.com"><g8ymh8uf001@sneakemail.com></a>
<span class="moz-txt-citetags">></span><a
class="moz-txt-link-freetext" href="http://www.hvcomputer.com">http://www.hvcomputer.com</a>
<span class="moz-txt-citetags">></span><a
class="moz-txt-link-freetext" href="http://www.fileProPlus.com">http://www.fileProPlus.com</a>
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">> </span>
<span class="moz-txt-citetags">></span>
</pre>
</blockquote>
<pre wrap=""><!---->Order isn't really significant here. I just want to make sure that all
instances of A1 and A7 are printed.
What happens if I sort by A1 and then A7? Will all instances be pulled
and show up on the report? Will they be pulled multiple times for the
same @AF? And, finally, can I do what I was thinking about with going
through @AF and using the PRINT command?
Boaz
**************************************************
I answered my own question after running a test so I'm putting it here for those who want to know what happens when you put two associated fields in the sort.
If there are two entries in A1 and 7 in A7 and A1 then you get 14 lines. The first seven are all duplicates of the first line and the next seven are all duplicates of the second line. So what it does is repeat each A1 entry as many times as it has A7 entires, but keeps the @AF stagnant with each A1 sorted iteration.
It looks like U have to use variables and arrays for this one.
Boaz
</pre>
</body>
</html>