nickrugado
MIS
I have a report requirement that shows quarterly sums in columns instead of rows.
I have accomplished something like this before by making each column it's own subreport. I don't know that this is the best way.
I have the following data summed up by company name and detailing out the following
Company A
Total Locations
Total SQft
Total Rent
Sum of Headcount
Avg Sq FT
Revenue per SF
Then across the page have the totals running down by quarter.
if this quarter is quarter 1 then the column heading order from left to right would be
qtr1'07 qtr4'06 qtr3'06 qtr2'06
if this quarter is quarter 3 then the column heading order from left to right would be
qtr3'07 qtr2'07 qtr1'07 qtr4'06
I know that I'm going to have to have fields on a query that are as dynamic so that the right criteria is brought it... I'm just wondering if Access has the capability to do the reporting?
I have accomplished something like this before by making each column it's own subreport. I don't know that this is the best way.
I have the following data summed up by company name and detailing out the following
Company A
Total Locations
Total SQft
Total Rent
Sum of Headcount
Avg Sq FT
Revenue per SF
Then across the page have the totals running down by quarter.
if this quarter is quarter 1 then the column heading order from left to right would be
qtr1'07 qtr4'06 qtr3'06 qtr2'06
if this quarter is quarter 3 then the column heading order from left to right would be
qtr3'07 qtr2'07 qtr1'07 qtr4'06
I know that I'm going to have to have fields on a query that are as dynamic so that the right criteria is brought it... I'm just wondering if Access has the capability to do the reporting?
