No “VALUES”, no parenthesis:
INSERT INTO Table2(LongIntColumn2, CurrencyColumn2)
SELECT LongIntColumn1, Avg(CurrencyColumn) as CurrencyColumn1 FROM Table1 GROUP BY LongIntColumn1;
More Related Contents:
- SQL Access ” Count “? [closed]
- How do I use parameters in VBA in the different contexts in Microsoft Access?
- Upserting in MS-access
- How to get matching data from another SQL table for two different columns: Inner Join and/or Union?
- Case expressions in Access
- How do I count unique items in field in Access query?
- Date Difference between consecutive rows
- Pivoting data in MS Access
- coalesce alternative in Access SQL
- Using Excel VBA to export data to MS Access table
- Top n records per group sql in access
- Does MS Access support “CASE WHEN” clause if connect with ODBC?
- Why does a LIKE query in Access not return any records?
- How to SUM two fields within an SQL query
- [] brackets in sql statements
- How to use system username directly in MS Access query?
- can we list all tables in msaccess database using sql?
- Use Access SQL to do a grouped ranking
- Access – compare two tables and update or insert data in first table
- Query for getting value from another record in same table and filter by difference greater than a gap threshold
- SQL Updating from an inner join
- “You tried to execute a query that does not include the specified aggregate function”
- How to delete in MS Access when using JOIN’s?
- SQL: Using NULL values vs. default values
- Editing Record issues in Access / SQL (Write Conflict)
- How to save the result of a SQL query into a variable in VBA?
- Select query with date condition
- Does MS access(2003) have anything comparable to Stored procedure. I want to run a complex query in MS acceess
- Microsoft Access – Case Query
- CONCAT equivalent in MS Access