Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2011
    Posts
    82

    Unanswered: Change Table layout

    Hello

    I have a table loaded into Access as follows:

    Day Census Period Weekday A B C D
    01 Midnight Monday 17 10 11 12
    01 Midday Monday 17 10 11 12
    02 Midnight Tuesday 17 10 11 12
    02 Midday Tuesday 17 10 11 12

    However what I need to achieve is a table as follows:


    01 Midnight Monday A 17
    01 Midday Monday A 17
    02 Midnight Tuesday A 17
    02 Midday Tuesday A 17
    01 Midnight Monday B 10
    01 Midday Monday B 10
    02 Midnight Tuesday B 10
    02 Midday Tuesday B 10

    ETC

    Can anyone help me achieve this?

    Thanks
    Helen

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    you could create a new table with your new design
    then run 4 update queries, or in realtity 4 Insert Into queries
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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