Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Sep 2002
    Location
    Brookings, South Dakota, USA
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report layout (Access XPpro)

    Hi, a user wants to have a report look like a table in word. Can you do that when you have fields with several records?
    Ex. I have a table with personal info and a table with tests. Each person has 10 or so tests in the assessment table with their results. This is how he wants the layout to be.

    XXXX test1 test2 test3 test4
    Name result result result result
    Name result result result result

    Any help will be appreciated. Thanks, Tammy

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Report layout (Access XPpro)

    What you could do is to setup an Unbound text field in the report and append to this field while the person stays the same. While you are appending you would make the detail section invisible, only making it visible on a change of person.

    If you really need specifics I will have to dig up a database I have done this with.
    Hope you get the gist of what I'm saying.

    Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  3. #3
    Lounger
    Join Date
    Sep 2002
    Location
    Brookings, South Dakota, USA
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report layout (Access XPpro)

    I wish I did understand, but unfortunately don't. I'll look in the help files now that I have the idea, but would love to see an example. Thank you,

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

    Re: Report layout (Access XPpro)

    If you didn't have a flat table, you could have used a crosstab query to make this easier. With the table design you described, there really is no easy way. The help files won't help, but look in the sample databases that came with your version of Access (i.e., Northwind, Orders, Solutions). If you didn't install the sample databases, they should still be on the Office CD.
    Charlotte

  5. #5
    Lounger
    Join Date
    Sep 2002
    Location
    Brookings, South Dakota, USA
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report layout (Access XPpro)

    My database has a table with personal info, a table with assessment results, and a table for assessments. The personal and assessment tables have a one to many relationship with the assessment results table, I didn't make that clear in my post. Can you do a crosstab query if you want more than 3 columns?

  6. #6
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Report layout (Access XPpro)

    As Charlotte indicated, you may want to try a Pivot Table. Go to Forms, New Forms, and try the Pivot Table Wizard. Base the wizard on a query that combines the data that you want.


    Another option would be to create a table in the format you want the report to look like. (Name, Test1, Test2, Test3, etc) Write some code that loops through the employee names and gets the test scores for each employee and then writes the data to the table. After all data is written to the table, Create a query that gets all of the data in this table and groups it by employee. Base the report on the query that grouped the data.

    I still think a pivot table is easier but this will work as well.

    HTH
    Regards,

    Gary
    (It's been a while!)

Posting Permissions

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