Hi,
Apologies for the thread title - unsure how to word this.
I have two tables with patient data - one called treatment data & one called weighing data.
Patient Number Patient Treatment Treatment Date Weight 1 T1 01/01/2019 97 1 T1 02/01/2019 77 4 T1 05/01/2019 90 5 T1 05/01/2019 87 3 T1 06/01/2019 88 2 T1 04/01/2019 69
Patient Number Weight Weigh Date Height 3 98 01/01/2019 97 3 62 02/01/2019 77 1 70 03/01/2019 90 4 89 05/01/2019 87 5 77 06/01/2019 88 2 65 04/01/2019 69
I'd like a query/formula that for this example returns patient 4 and patient 2 as they had treatment and a weight recorded on the same date.
Thanks!
Bookmarks