Make Table Query Error Message

[Guest]

I use this Make Table Query:

SELECT ParseISINTable.*, ParseISINTable.NSCCode INTO GroupTable
FROM ParseISINTable
WHERE (((ParseISINTable.NSCCode)=[NSCCode:]));

And Get this Error Message:

Cannot Define Field More than Once

Not sure what to do ?

Thank you in advance

 

[Brendan Reynolds]

In this line ...

SELECT ParseISINTable.*, ParseISINTable.NSCCode INTO GroupTable

The '*' symbol means 'all fields. That, of course, includes the field
'NSCCode'.

Change the above line to ...

SELECT ParseISINTable.* INTO GroupTable

 

[Someone]

Should the : be there after the last field name?

M