Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    225

    Unanswered: Changing Query data layout to suit my needs

    i have a query that currently displays the data that i require but not in the relevant way that i require.

    To chart the data i have i need to get two columns of data i currently have 5

    here is what i have:

    http://members.lycos.co.uk/redtilefc/1.jpg

    and this is what i am trying to get:

    http://members.lycos.co.uk/redtilefc/2.jpg

    i am not to worried about the spacing inbetween the data.

    looking at my attached Database can anyone suggest how i can rearrange my data please automatically to be two columns.

    on the form within my database is a picture of the chart i am trying to generate but require this info to be displayed in just 2 columns.

    my database has a query that holds dummy data, in my db, i run the query off of a number of tables but for an example have just populated a table with the data.

    Please help

    Andy
    Attached Files Attached Files

  2. #2
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    I am not sure if you can do that with a datasheet...Maybe having a form? Then make it like the second picture. My only problem is I don't know how to have access just make the correct number of rows, like for the lower half...

Posting Permissions

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