<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Comic Sans MS";
panose-1:3 15 7 2 3 3 2 2 2 4;}
@font-face
{font-family:"Lucida Calligraphy";
panose-1:3 1 1 1 1 1 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Keith,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">I don’t know if this approach is what you had in mind but have you looked at VEN.YTD.CHECK.CTR in the VENDORS file? It appears to be a check counter per vendor since the beginning of the fiscal year. Would
that help you?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">just wondering,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Pam<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Pam Yates<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Information Technology Services<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Kankakee Community College<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Kankakee, IL<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">(815) 802-8918<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><a href="mailto:pyates@kcc.edu">pyates@kcc.edu</a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> download-list-bounces@cedarville.edu [mailto:download-list-bounces@cedarville.edu]
<b>On Behalf Of </b>Johnson, Keith M<br>
<b>Sent:</b> Thursday, December 01, 2011 1:53 PM<br>
<b>To:</b> Cedarville DOWNLOAD Users<br>
<b>Subject:</b> [Download-List] question on making a report for vendors that have 3 or more checks since a date...?<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><i>Hi all,<o:p></o:p></i></p>
<p class="MsoNormal"><i>I have been toying with making a report that only shows vendors that have three checks since our current FY.<o:p></o:p></i></p>
<p class="MsoNormal"><i><o:p> </o:p></i></p>
<p class="MsoNormal"><i>The CC XCOUNTER just returns a numeral ‘1’ per check record. Other than going in to a subr can this be done at the DB level? I think I have done it years ago but cannot think of the way it’s done…<o:p></o:p></i></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">SELECT CHECKS WITH CHK.DATE GT '07/01/11' BY CHK.VENDOR AND WITH EVAL SUM 'XCOUNTER' GE 3
<i># blows up</i><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">LIST CHECKS BREAK.ON CHK.VENDOR EVAL "IF (TOTAL XCOUNTER) GT 3 THEN TOTAL XCOUNTER" DET.SUP NOPAGE
<i># blows up</i><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><i>These two base lines get me my report but include the vendors with only one or more checks since my date.<o:p></o:p></i></p>
<p class="MsoNormal">=========<o:p></o:p></p>
<p class="MsoNormal">SELECT CHECKS WITH CHK.DATE GT '07/01/11' BY CHK.VENDOR<o:p></o:p></p>
<p class="MsoNormal">LIST CHECKS BREAK.ON CHK.VENDOR TOTAL XCOUNTER DET.SUP NOPAGE<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><i>Ultimately I was thinking of doing something like the download example…<o:p></o:p></i></p>
<p class="MsoNormal">DOWNLOAD.TEST.PARAGRAPH<o:p></o:p></p>
<p class="MsoNormal">[…]<o:p></o:p></p>
<p class="MsoNormal">161: DISPLAY ===============================================================<o:p></o:p></p>
<p class="MsoNormal">162: DISPLAY 10 Testing EVAL and COL.HDG using comma-quote output<o:p></o:p></p>
<p class="MsoNormal">163: SELECT DOWNLOAD.TEST.FILE \<o:p></o:p></p>
<p class="MsoNormal">[…]<o:p></o:p></p>
<p class="MsoNormal">168<b>: EVAL "NUMERIC.FIELD+58"</b> \<o:p></o:p></p>
<p class="MsoNormal">169: COL.HDG "New Amount" \<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><i>TIA -KJ<o:p></o:p></i></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:13.5pt;font-family:"Lucida Calligraphy"">Keith Johnson<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Comic Sans MS"">Information Technology
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Comic Sans MS"">The College of Idaho
<a href="mailto:kmjohnson@collegeofidaho.edu"><span style="font-family:"Times New Roman","serif"">kmjohnson@collegeofidaho.edu</span></a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Comic Sans MS"">2112 Cleveland Blvd Caldwell, ID 83605
<a href="http://www.collegeofidaho.edu/"><span style="font-family:"Times New Roman","serif"">http://www.collegeofidaho.edu</span></a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Comic Sans MS"">Business: 208.459.5209<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Comic Sans MS"">Fax: 208.459.5543<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Comic Sans MS""><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:8.0pt;color:#1F497D">CONFIDENTIALITY NOTICE:</span></b><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#1F497D">
<i>This e-mail message is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you believe you have received this e-mail
in error please notify the sender. </i></span><span style="font-size:8.0pt;color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Comic Sans MS""><o:p> </o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>