Re: Need help displaying data

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: SA (~fake.address_at_nspm.com)
Date: 02/07/04 

Date: Sat, 7 Feb 2004 09:47:07 -0500

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: Sub report message
    ... performs the first join and then include that query in your SQL statement." ... Left join employee table to issue table. ... 1.I checked the main report query to see if there was a problem. ... All site staff are listed including all of the Food Service ...
    (microsoft.public.access.reports)
  • Re: Still Struggling...
    ... Dim rs As Object declares to the After Update event that rs is an Object. ... it's very different from a Bookmark in Word. ... report after I created that button. ... > I'm trying to do is create a drop-down list of employee last name,> first ...
    (microsoft.public.access.gettingstarted)
  • RE: Sub report message
    ... 1.I checked the main report query to see if there was a problem. ... All site staff are listed including all of the Food Service ... both employees have employee IDs that are not ... I assume it was referring to the IIF statement that you wanted me to place ...
    (microsoft.public.access.reports)
  • Re: Still Struggling...
    ... Dim rs as Object declares rs as an object variable. ... have only input 6 employee names using frmEmployees just so I can check to ... report after I created that button. ...
    (microsoft.public.access.gettingstarted)
  • RE: Sub report message
    ... appear in the key code section of the Site Employee report. ... the main and then in the Key Assignments query join the main query. ...
    (microsoft.public.access.reports)