Re: Need help displaying data

From: Tony Vrolyk (tvrolyk_at_NO_SPAMmlhg.net)
Date: 02/09/04 

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
> >
> >
> >
> >
> >
> >
> >
> >
>
>

Relevant Pages

  • Re: Reports with lines white
    ... How to repeat those dates for each employee? ... for that wanted that was done direct in the report. ...
    (microsoft.public.access.formscoding)
  • Re: Reports with lines white
    ... How to repeat those dates for each employee? ... for that wanted that was done direct in the report. ...
    (microsoft.public.access.reports)
  • Re: attachment and e-mail where to report these security issues?
    ... THAT is why the ENTIRE headers should be ... sent to the originating ISP, so the ISP can look up the correct originating ... report that DOES include the headers. ... >> has an infected system, don't you think they would like to know about it ...
    (microsoft.public.security.virus)
  • Re: How to cleanse a data file like this in VbScript
    ... > from a legacy system output as a text file it as some page headers and ... > headers I need to get rid of the page headers and column headers and ... > script code that can accomplish the cleaning. ... > It must take the data in the above report form with header and footers ...
    (microsoft.public.scripting.vbscript)
  • Re: Importing a .txt file issues
    ... If you record a macro when you open your .txt file, ... that cleans up the headers. ... Dim FoundCell As Range ... you get a text version of a report which is ...
    (microsoft.public.excel.misc)