insert a value in a query table

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

insert a value in a query table

Author

Topic

st0kvis
Starting Member

1 Post

Posted - 2012-01-23 : 04:18:58

i have created a sql query to fill a table in access 2010

my query table is Q_blocksarrived and the code used to form it is:

Code:

SELECT T_cellararrival.BlockName
FROM T_cellararrival
GROUP BY T_cellararrival.BlockName;

now i want to add a Please Select row in my column.

Any ideas?

biswajitdas
Starting Member

44 Posts

Posted - 2012-01-23 : 13:52:16

sorry little bit i confused here.you want a query which FILL a table which is in the access 2010.

INSERT INTO "table1" ("column1", "column2", ...)
SELECT "column3", "column4", ...
FROM "table2"

Sr Sql server DBA/Artitech

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources