Append AS

Posted on 2012-09-10
Last Modified: 2012-09-14
Is it possible to run a query appending records to it's own table with a change in the appended records.

I have a table that stores products. (By the 100s) Many products are identical and only perhaps the colour of the product changes. I want to be able to add a copy of a range of products (I have that part done ) and append to the same table but with a colour change picking that colour from a text box on a form. (I have that bit done also).

It's an append and update query together
Question by:DatabaseDek
    LVL 61

    Accepted Solution

    Try this - just substituting a reference to the combo for your color column:

    INSERT INTO table1 ( column1, column2, Column3, YourColorColumn) SELECT  column1, column2, column3, Forms!YourFormName!YourComboName) FROM    table1

    Open in new window


    Author Comment

    Simple and Brilliant. I will try that

    Author Closing Comment

    Sorry it took so long to try. But it work.

    Thank you

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now