Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    append tables (Access 2000)

    I am trying to append two tables, products and products1 with the following code:
    INSERT INTO products1 ( branch1 )SELECT products.branch1 FROM products;
    The table Products has 2 fields: productid and branch1.The Productid is an autonumber and branch1 is Number.However the appending seems not to follow the productid number.For example, the field branch1 for the productid is 6 but it is not shown in the results.I suspect i am doing
    a grave error in my code.May i have some help?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: append tables (Access 2000)

    Do you mean that a particular record for branch1 has a productID of 6 but when you append that record, the productID changes? If you don't append the productID field from the table as well as the branch1 field, then no, the productIDs won't be the same in the table you append to. That's why I suggested using the CLng() function to convert the ProductID to a long integer so it could also be appended to the other table in <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=acc&Number=74599&page=0 &view=collapsed&sb=5&o=186&fpart=>this thread</A>.
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    word of appeciation

    Dear Charlotte,

    I realy have to let you know that what you suggested about appending tables works excellent and you really helped me a lot indeed.I appreciate very much what you and your colleagues are doing

Posting Permissions

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