Table design question for estimated vs actual numbers (hours & dollars)

[mommyof4kids]

I need to capture estimated & actual hours & costs. I want to be able to run a report that will list the quarters & pay periods down the left hand side and across the top, the category with the estimated & actuals, by fiscal year for overtime tracking (example below)



Currently when I run my report I end up with all of FY16 (PP01-26) in the correct columns and then all of FY15 (in their correct columns, just after all of FY16)...how can I get PP01 for show on the same line under the correct columns? FY16 & FY15 ? (hope that makes sense)


We currently track this in Excel and would like to keep the same type of format....when I run my report it puts 2015 data for PP01 on line 1 and 2016 data for PP02 on line 2, etc...how can I get them side by side like I have it in Excel? All of the data is in the same table. I have FY16Actuals FY16Estimate FY16Cost, and the same for FY15s

[RuralGuy]

You can make Access Reports go to columns. That may work for you.