Good evening all,
I am currently trying to developing a database for a research project that will keep track of discharge medications, and will flag if a patient is discharged on more than one medication. However, the same medication given by different routes should only be counted as one. I have attached the database, with an example test patient.
In the attached database, frmOpening contains an unbound combo box (cmbPatientSelect) that lists all included patients. Once a patient is selected, clicking on the "Enter Data" button will bring up the form where data is entered; the table tblDCDrugs contains the data entered into the subform "Discharge medications" on frmPatientData.
In the example in the attached database, there are 5 records with 3 individual medications. I would like to create a query that returns "3" in this case (i.e., only counts unique values). Would someone be able to help me create something like this?
Thanks in advance for any help!