I have developed 2 main forms, one for the input and one for
choosing the criteria and outputting results. The input form transfers
results to the excel spreadsheet. The Criteria form takes the excel
spreadsheet results and then outputs criteria results in the form
itself in textboxes. My scenario is you have a combobox with choices of
where a patient is discharged to (cboDischargeTo) and choices are "Home"
"SNF/Rehab" and "Transfer_HRMC". These choices fill column ("d"). There
are options for the time they were discharged (opt12p, opt 3p etc...).
These choices fill column ("e"). In my criteria form I have
successfully been able to output how many patients were discharged, it
delineates the count of where they were discharged to (12 to Home, 10
to SNf etc...) It delineates how many were discharged at each time
slot. My problem is being able to fill a textbox with the answer from 2
criteria. Example:
If they were discharged to home and the time was at 3p I want the
textbox txtHome3p to fill in with the total of those patients meeting
that criteria. So I am able to do a count but can't combine the
criteria. I have been working on this for days and days, trying
everything I can think of. Any suggestions...Please...Thank-you.


--
alonge
------------------------------------------------------------------------
alonge's Profile: http://www.excelforum.com/member.php...o&userid=27874
View this thread: http://www.excelforum.com/showthread...hreadid=473781