Results 1 to 3 of 3
  1. #1
    Zoroxeus is offline Novice
    Windows Vista Access 2007
    Join Date
    Dec 2005
    Posts
    12

    One table, different data

    Hi,
    I have one single table
    I have different field:
    Name, level 1, level 2, level 3, level 4

    Name is always filed with something
    and each entry has at least an entry at level.
    The level field are numbers.

    So you could have something like:

    text 0, 2
    text 1, 2, 5, 2
    text 2, 2,2, 6
    text 3, 4
    text 4, 1
    text 5, 2,2,6,5

    you can't have level 4 filed without having level 2, 3 and 4 field


    Now i am stuck to represent the data in a report

    if you look at my sample data i want to show my report in this way:


    text 0


    |_____text 2
    |_____text 1
    |___text 5

    text 4
    text 3

    but i can't make the repoty show it this way... anyone has an idea please ?

  2. #2
    Join Date
    Dec 2006
    Posts
    5
    Try this: create a query as the data source for your report. On the query, make the level number a sort field (but leave the check box blank so it doesn't show in the query results). The select all the fields you want to print, including the level field. Your example is a little confusing to me, but it might work.

    jb

  3. #3
    Zoroxeus is offline Novice
    Windows Vista Access 2007
    Join Date
    Dec 2005
    Posts
    12
    thx, i gave up the project though

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Pull Data from another table
    By bbranco in forum Access
    Replies: 1
    Last Post: 06-19-2013, 06:15 AM
  2. Data won't show up in table field
    By texzen123 in forum Forms
    Replies: 3
    Last Post: 11-26-2009, 11:20 AM
  3. Call Excel Data into Access table
    By jiguvaidya in forum Import/Export Data
    Replies: 0
    Last Post: 09-15-2008, 04:58 AM
  4. Unmatched data entered with data in table
    By boreda in forum Access
    Replies: 0
    Last Post: 07-28-2006, 09:11 AM
  5. Replies: 3
    Last Post: 04-23-2006, 09:09 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums