Headings Across the Report

[Lupson2011]

Hi



I am trying to generate a report, wich deals in fiscal Year End's and financial data

All the Year Ends are drawn from one field Yr_End. However rather then have them running down the report page, is there any way to have them going across the page.

So, for example, if I want to show Voluntary Income and Restricted Income for all the year's. I really want to have the headings for the income going down the page, with the values for each year going across the page. With the Year End headings also going across the page?
2008/09 2009/10 2010/11
Vol Income
Restricted Income ???????? ????????? ?????????


Is this possible even, though the year end are all drawn from the same text field?

Any advice, as always welcome

bagpuss

[ssanfu]

Hi

I am trying to generate a report, wich deals in fiscal Year End's and financial data

All the Year Ends are drawn from one field Yr_End. However rather then have them running down the report page, is there any way to have them going across the page.

So, for example, if I want to show Voluntary Income and Restricted Income for all the year's. I really want to have the headings for the income going down the page, with the values for each year going across the page. With the Year End headings also going across the page?
2008/09 2009/10 2010/11
Vol Income
Restricted Income ???????? ????????? ?????????


Is this possible even, though the year end are all drawn from the same text field?

Any advice, as always welcome

bagpuss

Read up on CrossTab queries. This query rotates the query 90 deg. I believe there is a Crosstab query wizard in access.

[Lupson2011]

hi

I am aware of the cross tabs queries, but as far as I am aware you can only put a certain amount of fields in it or have i got that wrong?

bagpuss

[ssanfu]

hi

I am aware of the cross tabs queries, but as far as I am aware you can only put a certain amount of fields in it or have i got that wrong?

bagpuss

Sorry, I have only used a cross tab query once.

I kinda make my own "cross tab".here is what my query does. I create a totals query that has SSN in the left most column, the second column has the full name, the third has a calculation. For January the calculation is

JanPay: Sum(IIf(Month([hbh_effective])=1 And Year([hbh_effective])=[forms]![reportlist].[cboyear] And [hbh_hetfk]=2,[hbh_amount],0))

Same type of calculation for the other months.

[hbh_effective] is the date of payment stored in the table
[hbh_hetfk] is the type of entry (2 = payment)
[forms]![reportlist].[cboyear] is the control on the reports menu dialog box

[ssanfu]

Here is another site for crosstabs:

http://www.rogersaccesslibrary.com/forum/topic362.html