• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 363
  • Last Modified:

Append AS

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
0
DatabaseDek
Asked:
DatabaseDek
  • 2
1 Solution
 
mbizupCommented:
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

0
 
DatabaseDekAuthor Commented:
Simple and Brilliant. I will try that
0
 
DatabaseDekAuthor Commented:
Sorry it took so long to try. But it work.

Thank you
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now