CODEWITHSUNDEEP
ms-access
Vitali
Vitali

Reputation: 549

MS Access select fields from Textbox

I have a table with only one column, and before field it is plus sign, so that if I push it I see other columns and rows. Sorry for such an explanation, didn't find how it is named properly.

So, the question is how to create a table with some columns from this table. My attempt was:

SELECT ID, Name INTO NewTable
FROM Table
WHERE [Table.Column] = 'Value';

or even

SELECT ID, Name INTO NewTable
FROM Table.Column
WHERE [Table.Column] = 'Value';

Help please.

P.S. MS Access 2013

Upvotes: 0

Views: 407

Answers (1)

Gustav
Gustav

Reputation: 55831

You are probably after something like this:

SELECT ID, [Name] 
INTO NewTable
FROM Table
WHERE Table.[Column] = 'Value';

Upvotes: 1

Related Questions