I'm stuck trying to link tables which are essentially unrelated:
Table 1: is a list of test results associated with a ward on a particular day
e.g.
Load
CultureDate as Date
AttributableWard as Ward
TestResults
From Table1
Table 2: Aggregated figure of bed days per month by ward
e.g.
Load
Month as Date
Ward
OBDs
From Table2
When i link them It gives me a result, but the numbers of "TestResults" per month are not correct. I suspect it has something to do with the fact that the dates are in the same date format, but in table 2 are given as the first day of that month (for example, aggregated May 2020 data is listed as 1/05/2020).
