I'd like to Insert values from one Access Table into another
as well as a literal string value
My statement is as follows
Say Table 2 has one field: Sales
Table 1 has two fields, Month and Sales
I'd like to insert 10 into the month field of
table1 as well as the sales value from table2
This is how my statement looks thus far.
It produces an Insert into error.
Insert into TABLE1(Month,Sales)
Select "10" as Month, Sales from Table2
Thanks in advance.
Bookmarks