Report Format

[chickalina]

Hi,
I currently have a report that prints out the year totals as rows:

ex:
Information 2006 Amount
2007 Amount
2008 Amount

I want it to print this way:

2006 2007
2008
Information Amount Amount Amount

Can this be accomplished?

Also, when you click on the button to get to this report I want a little
screen to pop up so that you can put in the starting year and those year
numbers you see above will be the year entered into that box, plus 4.

I appreciate any help... I've been looking at this for quite some time,
playing with Detailed headers and such.

Thanks.

 

[Duane Hookom]

It isn't clear how your data is formatted. There is a FAQ at
http://www.tek-tips.com/faqs.cfm?fid=5466 which describes how to use months
as column headings in a report. Perhaps you can modify this to use years
rather than months.

 

[chickalina]

The table that stores the information is as follows:

IdeaID (primary key) relationship to parent table
QtrEndDate (primary key) user enters quarter end date
Amount
Reason for Change (if there is a change, this is a cbo bx and they choose one)

 

[Duane Hookom]

I expect the sample I suggested should work. Did you review it or attempt to
implement it?