I need to have the following in a sub form within a main form.
From the table Patients_Daily_Medications
with the fields below.
I need a crosstab query that would show me Medications as column heading and sequence as row heading and TimeGiven as the values.
See attached what the data looks like, and what I am trying to accomplish (not completed as you can see...)
At the end I would need this query as the record source of a form that has a patientID and a date as fields, so this should only return values of a sibgle patient at a particular day.
PS- Note TimeGiven has a date+time, we need to extract the Time only.
PS -, a VBA function that will open a recordset of that table, Accept two params (PatientID,Day) and return the following would also serve the purpose.
ALBUTEROL: 9:00 AM, 11:00 AM BUDESONIDE: 11:AM, 1:00PM, 5:00 PM MIRALAX: 3:PM
Thanks in advance.