Need help displaying data

  • Thread starter Thread starter Tony Vrolyk
  • Start date Start date
T

Tony Vrolyk

I am having trouble figuring out how to display some data the way I want.
First of all here is how my data is coming out have data in a query like
this.

PolicyID, Carrier, PlanName, Employee,CoverageChoice, PrimaryRate, LifeRate
2010, BCBSIL, 40,000 Series, Kelly Ahlberg, EE, $336.45, $5.40
2010, BCBSIL, 80,000 Series, Kelly Ahlberg, EE, $311.32, $5.40
2010, BCBSIL, Value Choice Series, Kelly Ahlberg, EE, $253.99, $5.40
2010, BCBSIL, Value Choice Series, Kelly Ahlberg, EE, $279.07, $5.40
2010, BCBSIL, 40,000 Series, Kenneth Fisk, EE/CH, $644.99, $5.40
2010, BCBSIL, 80,000 Series, Kenneth Fisk, EE/CH, $596.83, $5.40
2010, BCBSIL, Value Choice Series, Kenneth Fisk, EE/CH, $486.93, $5.40
2010, BCBSIL, Value Choice Series, Kenneth Fisk, EE/CH, $535.01, $5.40

I would use the PolicyID field as my linking data to the parent report. The
Carrier and PlanName would be heading of the data columns. The Employee name
and CoverageChoice would be used for left hand column as row headings and
the PrimaryRate and Life Rate would be repeated as need across to the right
with a sum at the bottom of each column.

The kicker is that there are not always 4 plans per employee as in this
sample. It could be 2 or 4 or 8 opr 7 or 12, you name it. So there would be
an undertermined number of columns. Ideally the row headings (Employee and
CoverageChoice ) would repeat on each page as needed.

I have another report where I have done something like this, except the left
hand row headings are just labels for the data displayed in each column.
Sample here
http://www.midwestlifeandhealth.com/pdfs/samplespread.pdf

In this case the left hand row headings are data in and of themselves. I did
a quck and dirty sample XLS that displays the data how I want it. Of course
I want to do this in and Access report if possible so It can be run in
conjucntion with the other report and share the same formating and layout.
Sample here
http://www.midwestlifeandhealth.com/pdfs/samplespreadcensus.pdf

Is what I am trying to do even possible with Access reports? Any help would
be appreciated. If you need more info just ask. I could show you the SQL
that gave me the above data but it is quite complex with 6 tables and 7
relationships.

Thanks
Tony Vrolyk
 
Tony:

Add a group header to your report and place the Policy ID, and Employee in
the Header. Then in the detail section, add the coverage choice, Plan Name,
rates etc.

Then in the File -> Page Set Up -> Columns tab, choose columns Across then
down. This will cause each to wrap; the only caveat to this is that you
don't get your headers repeated as the data goes across the detail section.

HTH
 
Thanks but that won't work. Not only the headers problem but the Employee
names must repeat in the left hanbd column on additinoal pages. I don't
think your suggestion would accomodate that.

I am starting to think the layout I want is beyond Access. If I can't get it
to work exaclty the way I want I will have to try a totally different
layout.

Thanks
Tony
 
Back
Top