We help IT Professionals succeed at work.

Count Logic

RaoVP
RaoVP asked
on
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
Comment
Watch Question

Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

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

mlmcc

Author

Commented:
Date Interval- 1/1/2011 to till date.
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

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

Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Look at this report

mlmcc
Q-27479249.rpt
Q-27479249-CountLogic.mdb
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

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