Error MEssage - Cannot Define Field More Than Once

[carl]

When I try to run the query below I get an error message "Cannot Define Field
More Than Once"

Not sure what I am doing wrong. Thank you in advance.

SELECT MMStream.*, [MMStream].[TraderId], Mid([ISIN],10,2) AS GroupCode INTO
Table919
FROM MMStream
WHERE ((([MMStream].[TraderId])="919S0A1") And
((Mid([ISIN],10,2))=Mid([ISIN],10,2)));

 

[MH]

SELECT MMStream.*, [MMStream].[TraderId],

TraderID is defined twice as the asterisk is used in the first argument.
Change to:

SELECT MMStream.*, Mid([ISIN],10,2) AS GroupCode

As you don't need it twice!

MH

When I try to run the query below I get an error message "Cannot Define
Field
More Than Once"

Not sure what I am doing wrong. Thank you in advance.

SELECT MMStream.*, [MMStream].[TraderId], Mid([ISIN],10,2) AS GroupCode
INTO
Table919
FROM MMStream
WHERE ((([MMStream].[TraderId])="919S0A1") And
((Mid([ISIN],10,2))=Mid([ISIN],10,2)));

 

[Ofer Cohen]

Remove the fields names and leave the *, try

SELECT MMStream.* INTO
Table919
FROM MMStream
WHERE ((([MMStream].[TraderId])="919S0A1") And
((Mid([ISIN],10,2))=Mid([ISIN],10,2)));