Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Plotting Values (Access2000)

    I'm trying to plot values into a grid or some sort of crosstab query to show compensation and contribution.
    Table is set up as follows. ID, name, compensation, contribution.
    The values for compensation and contribution are 10,20,&30. For low, medium, and high.
    I would like to have the persons name in the field that relates to their level of compensation and contribution.
    high compensation/low contribution, low compensation/low contribution etc.
    I don't think Access can show the type of grid I have in the picture but maybe 4 sub reports on a report for each combination.
    I've playes with some crosstab queries but can't get the names to show up where Ineed so I'm not sure if this is the way to go.
    Attached Images Attached Images

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Plotting Values (Access2000)

    1. Do you want to display one such diagram for each person (i.e. just one of the "cells" will be filled with the person's name, the rest will remain empty), or do you wish to display a diagram in which each cell is filled with a list of persons?

    2. What happens to value 20 ("medium")?

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Plotting Values (Access2000)

    Sorry but I'm not clear on what you want to show. Would you have a single grid for each person or did you want a grid showing everybody, with each name in the appropriate square? Does the 10, 20, 30 show up anywhere or is that just used to place the name?
    Charlotte

  4. #4
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Plotting Values (Access2000)

    Hans,
    The diagram would place each persons name in the grid(cell) that met the criteria for that cell.
    For 20,20 maybe I would have to place the values after the name so they could be seen. EG. John Doe 20,20 Dave Smith 20,30

    Charlotte,
    I want a grid showing everybody. The values were originally for computing in the queries. They don't necessarily have to be in the final output. Except for the 20,20 that Hans pointed out.
    Do either of you think this is doable?
    Thanks as always
    Scott

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Plotting Values (Access2000)

    If you are going to use a diagram, I wouldn't put the values after the names. If you would like to keep the 2 x 2 diagram, I would omit the persons with a value of 20 for either compensation or contribution; otherwise, create a 3 x 3 diagram.

    Create a query for each of the "cells", and create a simple columnar report for each of them (create one of them, then duplicate it and change the Record Source for the duplicates). Arrange them as subreports on a main report. If you know beforehand what the maximum number of persons in a cell will be, set the height of the subreports accordingly; otherwise, set their Can Grow and Can Shrink properties to Yes (as well as the Can Grow and Can Shrink properties of the section they're in.)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •