Display a Value from an interval

[crystles]

I have an Interval for Part Codes. It works correctly and will show the correct code if a Date within that interval (Transaction/Count) is available

Here is an example of a part, that has three intervals.

PartNumber	FromDate	ToDate	ChangeCode
13845	1/15/2017	3/9/2017	C
13845	10/15/2016	1/15/2017	B
13845	10/4/2015	10/15/2016	NA

I then have two "Transactions" or Counts of the part that I can show what the ChangeCode was for that specific Count date.

Counted	ABC Code when counted
3/24/2016	NA
10/26/2016	B

But NOW I need to show what that code was for each Quarter for the Current and Prior years, even if I don't have a Count in that Quarter.

I need two tables that will display the data as shown below, but I can't figure out how to get it to work correctly.

(NOTE: Our Fiscal Year starts in October)

Part	FY16 Q1	FY16 Q2	FY16 Q3	FY16 Q4
13845	NA	NA	NA	NA
Part	FY17 Q1	FY17 Q2	FY17 Q3	FY17 Q4
13845	B	C