Make Table Query Error Message

C

carl

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
 
B

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
 
Top