<div>
Are you running this for a particular month or for some date interval?<br />
<br />
mlmcc
</div>


Are you running this for a particular month or for some date interval?

mlmcc

<div>
Date Interval- 1/1/2011 to till date.
</div>


<div>
So Patient1 has appointments in Jan, feb, Mar, Apr, Jun, JUl, Aug, Sep, Oct, Nov<br />
Patient1 &nbsp;counts in May, Oct, Nov, and Dec but not in Jun, Jul, Aug, and Sep?<br />
<br />
Patient2 has Feb, Mar, Apr, May<br />
COunts in Jun but not May?<br />
<br />
mlmcc<br />
<br />

</div>


So Patient1 has appointments in Jan, feb, Mar, Apr, Jun, JUl, Aug, Sep, Oct, Nov
Patient1  counts in May, Oct, Nov, and Dec but not in Jun, Jul, Aug, and Sep?

Patient2 has Feb, Mar, Apr, May
COunts in Jun but not May?

mlmcc



Q-27479249-CountLogic.mdb

Q-27479249.rpt

<div>
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
</div>


This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

<div>
<div class="content wysiwyg-content">
Hi,<br />
I am working on logic but unable to find a way around it, can you guys please help me out.<br />
<br />
(1) There are Patient Results Coming into the Database Each Month.<br />
(2) I need to put a count Of patient Results Starting from the Month of may, In the Count the patient Will be included only if he has more the 4 months results. For eg: he will be included in May only if he has results for the Month of jan,Feb,March,Aprl<br />
(3) In jun also the count of patients will include, those patients who has more then 4 Months of Results earlier.<br />
<br />
Thanks<br />
VP
</div>
</div>


Hi,
I am working on logic but unable to find a way around it, can you guys please help me out.

(1) There are Patient Results Coming into the Database Each Month.
(2) I need to put a count Of patient Results Starting from the Month of may, In the Count the patient Will be included only if he has more the 4 months results. For eg: he will be included in May only if he has results for the Month of jan,Feb,March,Aprl
(3) In jun also the count of patients will include, those patients who has more then 4 Months of Results earlier.

Thanks
VP

Count Logic

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.