Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Aug 2006
    Indianapolis, Indiana, USA
    Thanked 0 Times in 0 Posts

    Stuck - Need Help (Access 2002)

    I am a State employee, but work with data we download from a federal database. The federal database has been upgraded and has changed a bunch.

    A record in the old system used to be like this:
    Field1, Field2, Field3, Field4, Field5, Field6

    The new system has split out Fields4-6 and created 3 records where there was one, like this:
    Field1, Field2, Field3, Field4
    Field1, Field2, Field3, Field5
    Field1, Field2, Field3, Field6

    What I need to do, believe it or not, is convert the three records back to one record so that we can work with the data. (Please don't laugh too much) <img src=/S/smile.gif border=0 alt=smile width=15 height=15>


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Stuck - Need Help (Access 2002)

    There's a free demo Normalize/Denormalize on Roger's Access Library. It demonstrates how to 'denormalize' a table.

Posting Permissions

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