horizontal grouping in ACCESS reports

K

karen in AZ

By default, ACCESS prints out grouped data in a vertical fashion. I want to
create a report that reads left to right, not top to down. Anyone know how
to make ACCESS reports work this way?

For example, if my highest order of grouping is by quarter, and my
subgrouping is by month, ACCESS will place the quarter on top and each month
below it, as such:

Q1
Jan 25%
Feb 30%
Mar 20%

However, I am seeking the following layout:

Q1 Q2
Jan Feb Mar Apr May Jun
2% 4% 6% 8% 7% 5%
 
K

KARL DEWEY

Try a crosstab query like this --
TRANSFORM Sum(DailyDieselLog.Amount) AS SumOfAmount
SELECT DailyDieselLog.Operator
FROM DailyDieselLog
GROUP BY DailyDieselLog.Operator
PIVOT "Q" & Format([FuelDate],"q") & " - " & Format([FuelDate],"mmm") In
("Q1 - JAN","Q1 - FEB","Q1 - MAR","Q2 - APR","Q2 - MAY","Q2 - JUN""Q3 -
JUL","Q3 - AUG","Q3 - SEP","Q4 - OCT","Q4 - NOV","Q4 - DEC");
 
D

Duane Hookom

You might want to take a look at the Montly Crosstab report solution found at
http://www.tek-tips.com/faqs.cfm?fid=5466.

--
Duane Hookom
Microsoft Access MVP


KARL DEWEY said:
Try a crosstab query like this --
TRANSFORM Sum(DailyDieselLog.Amount) AS SumOfAmount
SELECT DailyDieselLog.Operator
FROM DailyDieselLog
GROUP BY DailyDieselLog.Operator
PIVOT "Q" & Format([FuelDate],"q") & " - " & Format([FuelDate],"mmm") In
("Q1 - JAN","Q1 - FEB","Q1 - MAR","Q2 - APR","Q2 - MAY","Q2 - JUN""Q3 -
JUL","Q3 - AUG","Q3 - SEP","Q4 - OCT","Q4 - NOV","Q4 - DEC");


karen in AZ said:
By default, ACCESS prints out grouped data in a vertical fashion. I want to
create a report that reads left to right, not top to down. Anyone know how
to make ACCESS reports work this way?

For example, if my highest order of grouping is by quarter, and my
subgrouping is by month, ACCESS will place the quarter on top and each month
below it, as such:

Q1
Jan 25%
Feb 30%
Mar 20%

However, I am seeking the following layout:

Q1 Q2
Jan Feb Mar Apr May Jun
2% 4% 6% 8% 7% 5%
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top