Hello - I apologize if this has been asked/answered before but I'm not finding it and am having trouble even wording the type of query I want. Below is an example of what I'm trying to achieve.
Table Data Table Date Periods C1 C2 C3 D1 D2 D3 Person 1 7 200 Year 1 1 360 Person 2 249 1330 Year 2 361 720 Person 3 721 1750 Year 3 721 1080 Year 4 1081 1440 Year 5 1441 1800 Query Results C1 C2 C3 D1 Person 1 7 200 Year 1 Person 2 249 1330 Year 1 Person 2 249 1330 Year 2 Person 2 249 1330 Year 3 Person 2 249 1330 Year 4 Person 3 721 1750 Year 3 Person 3 721 1750 Year 4 Person 3 721 1750 Year 5
Now I'll try in words: I want to add a record to 'Table Data' for every record in 'Table Date Periods' starting where C2 is between D2 and D3 and ending where C3 is between D2 and D3.
Not sure if this makes sense but any help would be very much appreciated and I'm happy to try to clarify.
Thanks!