Re: Need help displaying data
From: Tony Vrolyk (tvrolyk_at_NO_SPAMmlhg.net)
Date: 02/09/04
- Next message: Kath: "How to incorporate If...Then...Else function in a report"
- Previous message: Jeff: "Calculations in Report, Null"
- In reply to: SA: "Re: Need help displaying data"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 9 Feb 2004 12:35:26 -0600
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
"SA" <~fake.address@nspm.com> wrote in message
news:OXGBElY7DHA.3420@TK2MSFTNGP11.phx.gbl...
> 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
> --
> Steve Arbaugh
> ACG Soft
> http://ourworld.compuserve.com/homepages/attac-cg
>
> "Tony Vrolyk" <tvrolyk@NO_SPAMmlhg.net> wrote in message
> news:uuTPdJN7DHA.2300@TK2MSFTNGP10.phx.gbl...
> > 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
> >
> >
> >
> >
> >
> >
> >
> >
>
>
- Next message: Kath: "How to incorporate If...Then...Else function in a report"
- Previous message: Jeff: "Calculations in Report, Null"
- In reply to: SA: "Re: Need help displaying data"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
