Insert Literal in Access Table using JETSQL
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. |
All times are GMT +1. The time now is 09:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com