Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post

    Making 3 records out of 1 (Access 2000)

    I have a table with 3 linked fields (Field1, Field2, Field3) and I would like to create a new table with a separate record for each of the three fields in the original table. Is there some convenient way to do this?

  2. #2
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Making 3 records out of 1 (Access 2000)

    Check out

    http://www.RogersAccessLibrary.com

    NormalizeDenormalize.mdb ( intermediate )
    It illustrates how to take a table which has fields like Value1, Value2, Value3,... and writes them into a table which has one field (Value) with each of the values in a new record rather than having them all in one record.

  3. #3
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Making 3 records out of 1 (Access 2000)

    Thanks for the suggestion. I had a look at the sample, but it was pretty hairy. I finally did the same thing with three append queries. At least I understood it better.

Posting Permissions

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