Error MEssage - Cannot Define Field More Than Once

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)));
 
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
Click to expand...

As you don't need it twice!

MH

carl said:
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)));
Click to expand...
 
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)));
 
Back
Top