formula to select combination of fileds

[jp246]

I need a foumula to pull this info:
report is neede for date of service_date - eg July 1 - 31, 2006

I need to have a count of care_type - palliative, long term, short term, and not assessed, but based on the assessment_date/

Here are some examples of the entries:

assessment_date care_type
July 15, 2006 long term - would be long term

example 2

July 15, 2006 long term
July 1, 2006 short term
if care type changes during the month of service date, then in this case the patient would be considered short term. the exception to this is if the patient became palliative, then palliative takes presedence.
example 3

August 2003 long term
this example would be long term

Thanks for your help, I am not a programmer, but an info analyst - I appreciate your help!!

 

[lbass]

You are in the wrong forum. Try the BO Crystal Reports Formula forum. You also need to define the specific criteria for each type of care.

-LB