I have been put into a postion of gathering information from reports and putting them into some type of coherent form. I have a model that allows me to sellect the FC of the patients seen by the hospital. The issue I have is that the Patient type does not continue thru the entire report as seen in the example. As with the first patient type 'E' there may be 241 (as in the example) or 15. I would like to be able to gather the patient type and the FC code for each. The Patient Type 'E' with all the variances of the FC Code.
TYPE NUMBER CODE AMOUNT DATE DATE DATE DATE
TOTAL NUMBER OF ACCOUNTS FOR PAT TYPE E IS 241
TOTAL NUMBER OF ACCOUNTS FOR PAT TYPE I IS 37
TOTAL NUMBER OF ACCOUNTS FOR PAT TYPE N IS 2
TOTAL NUMBER OF ACCOUNTS FOR PAT TYPE O IS 107
TOTAL NUMBER OF ACCOUNTS FOR PAT TYPE P IS 6
TOTAL NUMBER OF ACCOUNTS FOR RUN IS 393
TOTAL NUMBER OF INPATIENT ACCOUNTS IS 45
TOTAL NUMBER OF OUTPATIENT ACCOUNTS IS 348
The next part of the information is based upon date. I know that I can just put in the date and have it pull the information accordingly. I have been trying to use a formula to have it take what the current date is and then subtract however many days to get to the target date or dates.
Today would be 07-15-10 and the target date would be -4 days (07-11-10) or greater. None of the formulas that I have been trying work correctly.
I am using version 10 of monarch, Office 2007.
Thank you in advance.