Hi,
I spend alot of time trying to work this out but failed so please could
someone help.
Data:
(this table the intDay varies depending on the person)
Table1
Person | intDay
1 | 22
1 | 23
1 | 24
1 | 25
2 | 14
2 | 15
2 | 16
2 | 17
And below is the data which i want to combine with the table above. (the data
range always starts at 8 and -7 and should continue depending on how many
inDay a person have)
(data range/scale)
+day | -day
8 | -7
9 | -6
10 | -5
11 | -4
12 | -3
13 | -2
15 | -1
16 | 0
17 | 1
18 | 2
This is what i want the output to be(output to a table or report format):
Person | intDay | +day | -day
1 | 22 | 8 | -7
1 | 23 | 9 | -6
1 | 24 |10 | -5
1 | 25 | 11 | -4
2 | 14 | 8 | -7
2 | 15 | 9 | -6
2 | 16 | 10 | -5
2 | 17 |11 | -4
So basically for each person in the table, 'the data range/scale' matches
with it. And also is it possible to stop matching once the Person's intday
stops.
Thankyou for your help