Hi All,
Before starting this thread I reviewed all previous post but could not find a clue, I am using CR XI and Access 2003.
My scenario is like this.
I have to track patients with their previous admissions within 90 days, and then count them for particular Wards.
In the first step I pull all the records without any criteria becuase I want to check their prevous admissions as they might admitted in any ward.
In the Second Step I wrrote a formula based on their visit number,admission date,disharge date and for specific wards I check their Prevous admissions. For that I sorted my report visit number and admission date.
Here comes the probem let suppose I have all the admission with ward numbers like 101 102 103 105 106 107 108 108 109 and I have to report only 102 104 105 108 109. If I sort my report on Ward numnber and visit number then I cannot evaluate them properly and If I sort them on Visit number then I cannot group them by spcecific Ward Numbers.
(There are more than 100 wards and I have to report around 30-40 wards. )
I need some directions/guideline to achieve this scenario.
I will appreciate your help in this regard.
Before starting this thread I reviewed all previous post but could not find a clue, I am using CR XI and Access 2003.
My scenario is like this.
I have to track patients with their previous admissions within 90 days, and then count them for particular Wards.
In the first step I pull all the records without any criteria becuase I want to check their prevous admissions as they might admitted in any ward.
In the Second Step I wrrote a formula based on their visit number,admission date,disharge date and for specific wards I check their Prevous admissions. For that I sorted my report visit number and admission date.
Here comes the probem let suppose I have all the admission with ward numbers like 101 102 103 105 106 107 108 108 109 and I have to report only 102 104 105 108 109. If I sort my report on Ward numnber and visit number then I cannot evaluate them properly and If I sort them on Visit number then I cannot group them by spcecific Ward Numbers.
(There are more than 100 wards and I have to report around 30-40 wards. )
I need some directions/guideline to achieve this scenario.
I will appreciate your help in this regard.