Query: Additional Fields appearing

[manianz]

Hello

I have created a query linking 3 tables (with a total of about 4 Keys for linking the tables)

The data is output correctly. The only problem is the above field keys are appearing at the end of the Query as additional fields (and I do nort require them)
I am not able to eliminate these additional fields and they always get exported (to a Text file) even after hiding them

How can I eliminate them ?

 

[Mile-O]

Can you post the SQL?

 

[manianz]

Hello

Thanks for the interest shown

The below is the Code
(I am not conversant with Access.. and to add to it my OS is German which I am not conversant with..) The below code is Auto generated..
IBIPTLST, IBIPTLOP and IBIPTEXT are the Tables


SELECT IBIPTLST.[TCODE ], IBIPTLST.[RECORDNAME ], IBIPTLST.[EQUNR ], IBIPTLST.[TPLNR ], IBIPTLST.[PLNNR ], IBIPTLST.[PLNAL ], IBIPTLST.[KTEXT ], IBIPTLST.[ARBPL ], IBIPTLST.[WERKS ], IBIPTLST.[VERWE ], IBIPTLST.[VAGRP ], IBIPTLST.[STATU ], IBIPTLST.[STRAT ], IBIPTLST.[ANLZU ], IBIPTLST.[ISTRU ], IBIPTLST.[STTAG ], IBIPTLST.[AWERK ], IBIPTLST.[PLNNR_ALT ], IBIPTLST.[DELKZ ], IBIPTLST.[SLWBEZ ], IBIPTLST.[EXTNUM ], IBIPTLST.[ADPSP ], IBIPTLST.[TL_EXTID ], IBIPTLST.ENDOFRECORD, IBIPTLOP.[TCODE ], IBIPTLOP.[RECORDNAME ], IBIPTLOP.[VORNR ], IBIPTLOP.[UVORN ], IBIPTLOP.[ARBPL ], IBIPTLOP.[STEUS ], IBIPTLOP.[WERKS ], IBIPTLOP.[KTSCH ], IBIPTLOP.[LTXA1 ], IBIPTLOP.[LOANZ ], IBIPTLOP.[LOART ], IBIPTLOP.[QUALF ], IBIPTLOP.[LOGRP ], IBIPTLOP.[BZOFFB ], IBIPTLOP.[OFFSTB ], IBIPTLOP.[EHOFFB ], IBIPTLOP.[BZOFFE ], IBIPTLOP.[OFFSTE ], IBIPTLOP.[EHOFFE ], IBIPTLOP.[SORTL ], IBIPTLOP.[LIFNR ], IBIPTLOP.[PLIFZ ], IBIPTLOP.[PREIS ], IBIPTLOP.[WAERS ], IBIPTLOP.[PEINH ], IBIPTLOP.[SAKTO ], IBIPTLOP.[INFNR ], IBIPTLOP.[EKORG ], IBIPTLOP.[EKGRP ], IBIPTLOP.[MATKL ], IBIPTLOP.[DAUNO ], IBIPTLOP.[DAUNE ], IBIPTLOP.[DAUMI ], IBIPTLOP.[DAUME ], IBIPTLOP.[ARBEI ], IBIPTLOP.[ARBEH ], IBIPTLOP.[ANZZL ], IBIPTLOP.[PRZNT ], IBIPTLOP.[VERTN ], IBIPTLOP.[SLWID ], IBIPTLOP.[USR00 ], IBIPTLOP.[USR01 ], IBIPTLOP.[USR02 ], IBIPTLOP.[USR03 ], IBIPTLOP.[USR04 ], IBIPTLOP.[USE04 ], IBIPTLOP.[USR05 ], IBIPTLOP.[USE05 ], IBIPTLOP.[USR06 ], IBIPTLOP.[USE06 ], IBIPTLOP.[USR07 ], IBIPTLOP.[USE07 ], IBIPTLOP.[USR08 ], IBIPTLOP.[USR09 ], IBIPTLOP.[USR10 ], IBIPTLOP.[USR11 ], IBIPTLOP.[INDET ], IBIPTLOP.[LARNT ], IBIPTLOP.[ANLZU ], IBIPTLOP.[ISTRU ], IBIPTLOP.[BMEIH ], IBIPTLOP.[BMVRG ], IBIPTLOP.[AUFKT ], IBIPTLOP.[KZLGF ], IBIPTLOP.[EBELN ], IBIPTLOP.[EBELP ], IBIPTLOP.ENDOFRECORD, IBIPTEXT.[RECORDNAME ], IBIPTEXT.[TXPARGRAPH ], IBIPTEXT.[TXLINE ], IBIPTEXT.[TEXT_MARK ], *
FROM (IBIPTLST INNER JOIN IBIPTLOP ON IBIPTLST.SERIALNO = IBIPTLOP.SERIALNO) LEFT JOIN IBIPTEXT ON (IBIPTLOP.SERIALNO = IBIPTEXT.SERIALNO) AND (IBIPTLOP.[VORNR ] = IBIPTEXT.OPNO) AND (IBIPTLOP.[UVORN ] = IBIPTEXT.SOPNO)
ORDER BY IBIPTLST.[TPLNR ], IBIPTLOP.[VORNR ], IBIPTLOP.[UVORN ];