Hello...
I have a query that returns a number of fields from a table, i.e.
Effective Date Employees Premium Increase ETC....
Sept 2002 22 $34.00 10.56%
Oct 2002 24 $54.00 13.56%
Now, I want to create a report using the query. The catch is that I need to transpose the data for the reports, i.e.
Sept 2002 Oct 2002 ......
Employees 22 24
Premium $34.00 $54.00
Increase 10.56% 13.56%
A crosstab query will not work, since there are multiple fields that I need a value for...
I have gotten it working using the Column feature in the report...However, since the labels (on the left) are included in the detail section, they repeat each column, which I do not want.
So, my questions is, is it possible to hide controls within the Detail Section of a report if the record being displayed is no the first record?
Also, stepping back, is there a better way of tackling this problem altogether? I created a module to dump the data into Excel and Transpose it there...But I would prefer to contain the report within Access.
Any help would be greatly appreciated.
I have a query that returns a number of fields from a table, i.e.
Effective Date Employees Premium Increase ETC....
Sept 2002 22 $34.00 10.56%
Oct 2002 24 $54.00 13.56%
Now, I want to create a report using the query. The catch is that I need to transpose the data for the reports, i.e.
Sept 2002 Oct 2002 ......
Employees 22 24
Premium $34.00 $54.00
Increase 10.56% 13.56%
A crosstab query will not work, since there are multiple fields that I need a value for...
I have gotten it working using the Column feature in the report...However, since the labels (on the left) are included in the detail section, they repeat each column, which I do not want.
So, my questions is, is it possible to hide controls within the Detail Section of a report if the record being displayed is no the first record?
Also, stepping back, is there a better way of tackling this problem altogether? I created a module to dump the data into Excel and Transpose it there...But I would prefer to contain the report within Access.
Any help would be greatly appreciated.
