Make Table Query - Too Many Fields

B

Ben

Hi,

I am running a query that only has 102 fields. Of the 102 fields, only 2 of
them have criteria. I'm getting the Too Many Fields message which is
confusing me since Help states that message is for over 255 fields.

The table that it is querying has just under 13 million records. I try to
use a Filter on the table to get the data that I need, but it always times
out.

Any idea on the error message?

Ben
 
K

Klatuu

I don't know if the message would be different, but there is also a 4000
character limit to the size of a record.
 
J

John Spencer

Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

Also, does the query refer to other queries?

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
B

Ben

Hi - this query doesn't refer to other queries. SQL shown below:

SELECT BDSSDMMGR_NFS_TRD_REV.*, BDSSDMMGR_NFS_TRD_REV.CYC_DT,
BDSSDMMGR_NFS_TRD_REV.BUY_SELL_IND, BDSSDMMGR_NFS_TRD_REV.TRD_DT,
BDSSDMMGR_NFS_TRD_REV.SETL_DT, BDSSDMMGR_NFS_TRD_REV.MKT_CD,
BDSSDMMGR_NFS_TRD_REV.BLTR_CD, BDSSDMMGR_NFS_TRD_REV.CNCL_IND,
BDSSDMMGR_NFS_TRD_REV.CORR_CD, BDSSDMMGR_NFS_TRD_REV.ACCT_NBR,
BDSSDMMGR_NFS_TRD_REV.CUSIP, BDSSDMMGR_NFS_TRD_REV.BAS_PRC_CALC_CD,
BDSSDMMGR_NFS_TRD_REV.RUN_DT, BDSSDMMGR_NFS_TRD_REV.USR_REF_NBR,
BDSSDMMGR_NFS_TRD_REV.SYMB, BDSSDMMGR_NFS_TRD_REV.SCRTY_TYPE_CD,
BDSSDMMGR_NFS_TRD_REV.SCRTY_MOD_CD, BDSSDMMGR_NFS_TRD_REV.SCRTY_CALC_CD,
BDSSDMMGR_NFS_TRD_REV.RGST_REP, BDSSDMMGR_NFS_TRD_REV.SCRTY_CD,
BDSSDMMGR_NFS_TRD_REV.CMSN_ACCUM_IND, BDSSDMMGR_NFS_TRD_REV.CMSN_SCHD,
BDSSDMMGR_NFS_TRD_REV.CMSN_CNCS_CD, BDSSDMMGR_NFS_TRD_REV.QTY,
BDSSDMMGR_NFS_TRD_REV.PRC, BDSSDMMGR_NFS_TRD_REV.BAS_PRC,
BDSSDMMGR_NFS_TRD_REV.PLUS_MINUS_AMT, BDSSDMMGR_NFS_TRD_REV.PRIN_AMT,
BDSSDMMGR_NFS_TRD_REV.INT_AMT, BDSSDMMGR_NFS_TRD_REV.CMSN_AMT,
BDSSDMMGR_NFS_TRD_REV.STATE_TAX, BDSSDMMGR_NFS_TRD_REV.SCRTY_FEE,
BDSSDMMGR_NFS_TRD_REV.CERT_FEE, BDSSDMMGR_NFS_TRD_REV.PSTG,
BDSSDMMGR_NFS_TRD_REV.SRV_CHRG_MISC_FEE, BDSSDMMGR_NFS_TRD_REV.NET_AMT,
BDSSDMMGR_NFS_TRD_REV.BRKG_AMT, BDSSDMMGR_NFS_TRD_REV.CNCS_AMT,
BDSSDMMGR_NFS_TRD_REV.OTHR_EXCH_CMSN_AMT, BDSSDMMGR_NFS_TRD_REV.DESC_LINE_1,
BDSSDMMGR_NFS_TRD_REV.DESC_LINE_2, BDSSDMMGR_NFS_TRD_REV.DESC_LINE_3,
BDSSDMMGR_NFS_TRD_REV.DESC_LINE_4, BDSSDMMGR_NFS_TRD_REV.DESC_LINE_5,
BDSSDMMGR_NFS_TRD_REV.DESC_LINE_6, BDSSDMMGR_NFS_TRD_REV.DESC_LINE_7,
BDSSDMMGR_NFS_TRD_REV.DESC_LINE_8, BDSSDMMGR_NFS_TRD_REV.DESC_LINE_9,
BDSSDMMGR_NFS_TRD_REV.AUTO_LGND_1, BDSSDMMGR_NFS_TRD_REV.AUTO_LGND_2,
BDSSDMMGR_NFS_TRD_REV.RGST_REP_CD_2, BDSSDMMGR_NFS_TRD_REV.RGST_REP_CD_3,
BDSSDMMGR_NFS_TRD_REV.CMSN_PCT_DISC, BDSSDMMGR_NFS_TRD_REV.STRK_PRC,
BDSSDMMGR_NFS_TRD_REV.DUE_BILL_MULT, BDSSDMMGR_NFS_TRD_REV.LOAD_OVRD_PCT,
BDSSDMMGR_NFS_TRD_REV.ENTRY_QTY_TYPE,
BDSSDMMGR_NFS_TRD_REV.CONF_LINE_NO_FLAG,
BDSSDMMGR_NFS_TRD_REV.EXCH_LINE_NO_FLAG, BDSSDMMGR_NFS_TRD_REV.TRDG_AWAY_IND,
BDSSDMMGR_NFS_TRD_REV.BR_NBR, BDSSDMMGR_NFS_TRD_REV.MKT_SEQ,
BDSSDMMGR_NFS_TRD_REV.ADDL_MRKP, BDSSDMMGR_NFS_TRD_REV.SGNON_RGST_REP,
BDSSDMMGR_NFS_TRD_REV.OWNG_RGST_REP, BDSSDMMGR_NFS_TRD_REV.FUND_LOAD_PCT,
BDSSDMMGR_NFS_TRD_REV.PROD_CD, BDSSDMMGR_NFS_TRD_REV.TWELVEB1_IND,
BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_CD_1, BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_AMT_1,
BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_CD_2, BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_AMT_2,
BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_CD_3, BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_AMT_3,
BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_CD_4, BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_AMT_4,
BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_CD_5, BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_AMT_5,
BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_CD_6, BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_AMT_6,
BDSSDMMGR_NFS_TRD_REV.REV_CLR_CHRG_SGN,
BDSSDMMGR_NFS_TRD_REV.REV_CLR_CHRG_AMT,
BDSSDMMGR_NFS_TRD_REV.REV_MISC_FEE_SGN,
BDSSDMMGR_NFS_TRD_REV.REV_MISC_FEE_AMT, BDSSDMMGR_NFS_TRD_REV.REV_PROD_LVL,
BDSSDMMGR_NFS_TRD_REV.REV_CNCS_LOAD_IND, BDSSDMMGR_NFS_TRD_REV.REV_PRCH_TYPE,
BDSSDMMGR_NFS_TRD_REV.REV_CMSN_SGN, BDSSDMMGR_NFS_TRD_REV.REV_CMSN_AMT,
BDSSDMMGR_NFS_TRD_REV.REV_CNCS_SGN, BDSSDMMGR_NFS_TRD_REV.REV_CNCS_AMT,
BDSSDMMGR_NFS_TRD_REV.REV_LOAD_SGN, BDSSDMMGR_NFS_TRD_REV.REV_LOAD_AMT,
BDSSDMMGR_NFS_TRD_REV.ORDR_REF_NBR, BDSSDMMGR_NFS_TRD_REV.INPT_CMSN_SGN,
BDSSDMMGR_NFS_TRD_REV.INPT_CMSN_AMT INTO [SDA 2006]
FROM BDSSDMMGR_NFS_TRD_REV
WHERE (((BDSSDMMGR_NFS_TRD_REV.BR_NBR)="PVK" Or
(BDSSDMMGR_NFS_TRD_REV.BR_NBR)="PVS"));
 
M

Michel Walsh

The limit may be applicable to previous fields/expressions you may have
removed (ie, like control in a FORM, the limit is an HISTORICAL limit). Try
to compact your database OR cut and paste the SQL code into a new query.


Vanderghast, Access MVP



Ben said:
Hi - this query doesn't refer to other queries. SQL shown below:

SELECT BDSSDMMGR_NFS_TRD_REV.*, BDSSDMMGR_NFS_TRD_REV.CYC_DT,
BDSSDMMGR_NFS_TRD_REV.BUY_SELL_IND, BDSSDMMGR_NFS_TRD_REV.TRD_DT,
BDSSDMMGR_NFS_TRD_REV.SETL_DT, BDSSDMMGR_NFS_TRD_REV.MKT_CD,
BDSSDMMGR_NFS_TRD_REV.BLTR_CD, BDSSDMMGR_NFS_TRD_REV.CNCL_IND,
BDSSDMMGR_NFS_TRD_REV.CORR_CD, BDSSDMMGR_NFS_TRD_REV.ACCT_NBR,
BDSSDMMGR_NFS_TRD_REV.CUSIP, BDSSDMMGR_NFS_TRD_REV.BAS_PRC_CALC_CD,
BDSSDMMGR_NFS_TRD_REV.RUN_DT, BDSSDMMGR_NFS_TRD_REV.USR_REF_NBR,
BDSSDMMGR_NFS_TRD_REV.SYMB, BDSSDMMGR_NFS_TRD_REV.SCRTY_TYPE_CD,
BDSSDMMGR_NFS_TRD_REV.SCRTY_MOD_CD, BDSSDMMGR_NFS_TRD_REV.SCRTY_CALC_CD,
BDSSDMMGR_NFS_TRD_REV.RGST_REP, BDSSDMMGR_NFS_TRD_REV.SCRTY_CD,
BDSSDMMGR_NFS_TRD_REV.CMSN_ACCUM_IND, BDSSDMMGR_NFS_TRD_REV.CMSN_SCHD,
BDSSDMMGR_NFS_TRD_REV.CMSN_CNCS_CD, BDSSDMMGR_NFS_TRD_REV.QTY,
BDSSDMMGR_NFS_TRD_REV.PRC, BDSSDMMGR_NFS_TRD_REV.BAS_PRC,
BDSSDMMGR_NFS_TRD_REV.PLUS_MINUS_AMT, BDSSDMMGR_NFS_TRD_REV.PRIN_AMT,
BDSSDMMGR_NFS_TRD_REV.INT_AMT, BDSSDMMGR_NFS_TRD_REV.CMSN_AMT,
BDSSDMMGR_NFS_TRD_REV.STATE_TAX, BDSSDMMGR_NFS_TRD_REV.SCRTY_FEE,
BDSSDMMGR_NFS_TRD_REV.CERT_FEE, BDSSDMMGR_NFS_TRD_REV.PSTG,
BDSSDMMGR_NFS_TRD_REV.SRV_CHRG_MISC_FEE, BDSSDMMGR_NFS_TRD_REV.NET_AMT,
BDSSDMMGR_NFS_TRD_REV.BRKG_AMT, BDSSDMMGR_NFS_TRD_REV.CNCS_AMT,
BDSSDMMGR_NFS_TRD_REV.OTHR_EXCH_CMSN_AMT,
BDSSDMMGR_NFS_TRD_REV.DESC_LINE_1,
BDSSDMMGR_NFS_TRD_REV.DESC_LINE_2, BDSSDMMGR_NFS_TRD_REV.DESC_LINE_3,
BDSSDMMGR_NFS_TRD_REV.DESC_LINE_4, BDSSDMMGR_NFS_TRD_REV.DESC_LINE_5,
BDSSDMMGR_NFS_TRD_REV.DESC_LINE_6, BDSSDMMGR_NFS_TRD_REV.DESC_LINE_7,
BDSSDMMGR_NFS_TRD_REV.DESC_LINE_8, BDSSDMMGR_NFS_TRD_REV.DESC_LINE_9,
BDSSDMMGR_NFS_TRD_REV.AUTO_LGND_1, BDSSDMMGR_NFS_TRD_REV.AUTO_LGND_2,
BDSSDMMGR_NFS_TRD_REV.RGST_REP_CD_2, BDSSDMMGR_NFS_TRD_REV.RGST_REP_CD_3,
BDSSDMMGR_NFS_TRD_REV.CMSN_PCT_DISC, BDSSDMMGR_NFS_TRD_REV.STRK_PRC,
BDSSDMMGR_NFS_TRD_REV.DUE_BILL_MULT, BDSSDMMGR_NFS_TRD_REV.LOAD_OVRD_PCT,
BDSSDMMGR_NFS_TRD_REV.ENTRY_QTY_TYPE,
BDSSDMMGR_NFS_TRD_REV.CONF_LINE_NO_FLAG,
BDSSDMMGR_NFS_TRD_REV.EXCH_LINE_NO_FLAG,
BDSSDMMGR_NFS_TRD_REV.TRDG_AWAY_IND,
BDSSDMMGR_NFS_TRD_REV.BR_NBR, BDSSDMMGR_NFS_TRD_REV.MKT_SEQ,
BDSSDMMGR_NFS_TRD_REV.ADDL_MRKP, BDSSDMMGR_NFS_TRD_REV.SGNON_RGST_REP,
BDSSDMMGR_NFS_TRD_REV.OWNG_RGST_REP, BDSSDMMGR_NFS_TRD_REV.FUND_LOAD_PCT,
BDSSDMMGR_NFS_TRD_REV.PROD_CD, BDSSDMMGR_NFS_TRD_REV.TWELVEB1_IND,
BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_CD_1, BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_AMT_1,
BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_CD_2, BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_AMT_2,
BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_CD_3, BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_AMT_3,
BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_CD_4, BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_AMT_4,
BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_CD_5, BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_AMT_5,
BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_CD_6, BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_AMT_6,
BDSSDMMGR_NFS_TRD_REV.REV_CLR_CHRG_SGN,
BDSSDMMGR_NFS_TRD_REV.REV_CLR_CHRG_AMT,
BDSSDMMGR_NFS_TRD_REV.REV_MISC_FEE_SGN,
BDSSDMMGR_NFS_TRD_REV.REV_MISC_FEE_AMT,
BDSSDMMGR_NFS_TRD_REV.REV_PROD_LVL,
BDSSDMMGR_NFS_TRD_REV.REV_CNCS_LOAD_IND,
BDSSDMMGR_NFS_TRD_REV.REV_PRCH_TYPE,
BDSSDMMGR_NFS_TRD_REV.REV_CMSN_SGN, BDSSDMMGR_NFS_TRD_REV.REV_CMSN_AMT,
BDSSDMMGR_NFS_TRD_REV.REV_CNCS_SGN, BDSSDMMGR_NFS_TRD_REV.REV_CNCS_AMT,
BDSSDMMGR_NFS_TRD_REV.REV_LOAD_SGN, BDSSDMMGR_NFS_TRD_REV.REV_LOAD_AMT,
BDSSDMMGR_NFS_TRD_REV.ORDR_REF_NBR, BDSSDMMGR_NFS_TRD_REV.INPT_CMSN_SGN,
BDSSDMMGR_NFS_TRD_REV.INPT_CMSN_AMT INTO [SDA 2006]
FROM BDSSDMMGR_NFS_TRD_REV
WHERE (((BDSSDMMGR_NFS_TRD_REV.BR_NBR)="PVK" Or
(BDSSDMMGR_NFS_TRD_REV.BR_NBR)="PVS"));


John Spencer said:
Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

Also, does the query refer to other queries?

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
Click to expand...
Click to expand...
 
J

John Spencer

Well part of the problem is that you have the wild card for ALL fields in the
SELECT clause and then you list specific fields - so you are going to end up
with duplicate fields trying to insert into your table

SELECT BDSSDMMGR_NFS_TRD_REV.*, BDSSDMMGR_NFS_TRD_REV.CYC_DT,

AND I don't know how many field are in the table BDSSDMMGR_NFS_TRD_REV but
that could account for exceeding the maximum number of fields (95 fields
listed plus the number of fields in the table). Or it could just be a bad
error message.

Try changing the SQL to
SELECT BDSSDMMGR_NFS_TRD_REV.CYC_DT,
BDSSDMMGR_NFS_TRD_REV.BUY_SELL_IND, BDSSDMMGR_NFS_TRD_REV.TRD_DT,
....


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
Hi - this query doesn't refer to other queries. SQL shown below:

SELECT BDSSDMMGR_NFS_TRD_REV.*, BDSSDMMGR_NFS_TRD_REV.CYC_DT,
BDSSDMMGR_NFS_TRD_REV.BUY_SELL_IND, BDSSDMMGR_NFS_TRD_REV.TRD_DT,
BDSSDMMGR_NFS_TRD_REV.SETL_DT, BDSSDMMGR_NFS_TRD_REV.MKT_CD,
BDSSDMMGR_NFS_TRD_REV.BLTR_CD, BDSSDMMGR_NFS_TRD_REV.CNCL_IND,
BDSSDMMGR_NFS_TRD_REV.CORR_CD, BDSSDMMGR_NFS_TRD_REV.ACCT_NBR,
BDSSDMMGR_NFS_TRD_REV.CUSIP, BDSSDMMGR_NFS_TRD_REV.BAS_PRC_CALC_CD,
BDSSDMMGR_NFS_TRD_REV.RUN_DT, BDSSDMMGR_NFS_TRD_REV.USR_REF_NBR,
BDSSDMMGR_NFS_TRD_REV.SYMB, BDSSDMMGR_NFS_TRD_REV.SCRTY_TYPE_CD,
BDSSDMMGR_NFS_TRD_REV.SCRTY_MOD_CD, BDSSDMMGR_NFS_TRD_REV.SCRTY_CALC_CD,
BDSSDMMGR_NFS_TRD_REV.RGST_REP, BDSSDMMGR_NFS_TRD_REV.SCRTY_CD,
BDSSDMMGR_NFS_TRD_REV.CMSN_ACCUM_IND, BDSSDMMGR_NFS_TRD_REV.CMSN_SCHD,
BDSSDMMGR_NFS_TRD_REV.CMSN_CNCS_CD, BDSSDMMGR_NFS_TRD_REV.QTY,
BDSSDMMGR_NFS_TRD_REV.PRC, BDSSDMMGR_NFS_TRD_REV.BAS_PRC,
BDSSDMMGR_NFS_TRD_REV.PLUS_MINUS_AMT, BDSSDMMGR_NFS_TRD_REV.PRIN_AMT,
BDSSDMMGR_NFS_TRD_REV.INT_AMT, BDSSDMMGR_NFS_TRD_REV.CMSN_AMT,
BDSSDMMGR_NFS_TRD_REV.STATE_TAX, BDSSDMMGR_NFS_TRD_REV.SCRTY_FEE,
BDSSDMMGR_NFS_TRD_REV.CERT_FEE, BDSSDMMGR_NFS_TRD_REV.PSTG,
BDSSDMMGR_NFS_TRD_REV.SRV_CHRG_MISC_FEE, BDSSDMMGR_NFS_TRD_REV.NET_AMT,
BDSSDMMGR_NFS_TRD_REV.BRKG_AMT, BDSSDMMGR_NFS_TRD_REV.CNCS_AMT,
BDSSDMMGR_NFS_TRD_REV.OTHR_EXCH_CMSN_AMT, BDSSDMMGR_NFS_TRD_REV.DESC_LINE_1,
BDSSDMMGR_NFS_TRD_REV.DESC_LINE_2, BDSSDMMGR_NFS_TRD_REV.DESC_LINE_3,
BDSSDMMGR_NFS_TRD_REV.DESC_LINE_4, BDSSDMMGR_NFS_TRD_REV.DESC_LINE_5,
BDSSDMMGR_NFS_TRD_REV.DESC_LINE_6, BDSSDMMGR_NFS_TRD_REV.DESC_LINE_7,
BDSSDMMGR_NFS_TRD_REV.DESC_LINE_8, BDSSDMMGR_NFS_TRD_REV.DESC_LINE_9,
BDSSDMMGR_NFS_TRD_REV.AUTO_LGND_1, BDSSDMMGR_NFS_TRD_REV.AUTO_LGND_2,
BDSSDMMGR_NFS_TRD_REV.RGST_REP_CD_2, BDSSDMMGR_NFS_TRD_REV.RGST_REP_CD_3,
BDSSDMMGR_NFS_TRD_REV.CMSN_PCT_DISC, BDSSDMMGR_NFS_TRD_REV.STRK_PRC,
BDSSDMMGR_NFS_TRD_REV.DUE_BILL_MULT, BDSSDMMGR_NFS_TRD_REV.LOAD_OVRD_PCT,
BDSSDMMGR_NFS_TRD_REV.ENTRY_QTY_TYPE,
BDSSDMMGR_NFS_TRD_REV.CONF_LINE_NO_FLAG,
BDSSDMMGR_NFS_TRD_REV.EXCH_LINE_NO_FLAG, BDSSDMMGR_NFS_TRD_REV.TRDG_AWAY_IND,
BDSSDMMGR_NFS_TRD_REV.BR_NBR, BDSSDMMGR_NFS_TRD_REV.MKT_SEQ,
BDSSDMMGR_NFS_TRD_REV.ADDL_MRKP, BDSSDMMGR_NFS_TRD_REV.SGNON_RGST_REP,
BDSSDMMGR_NFS_TRD_REV.OWNG_RGST_REP, BDSSDMMGR_NFS_TRD_REV.FUND_LOAD_PCT,
BDSSDMMGR_NFS_TRD_REV.PROD_CD, BDSSDMMGR_NFS_TRD_REV.TWELVEB1_IND,
BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_CD_1, BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_AMT_1,
BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_CD_2, BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_AMT_2,
BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_CD_3, BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_AMT_3,
BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_CD_4, BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_AMT_4,
BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_CD_5, BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_AMT_5,
BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_CD_6, BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_AMT_6,
BDSSDMMGR_NFS_TRD_REV.REV_CLR_CHRG_SGN,
BDSSDMMGR_NFS_TRD_REV.REV_CLR_CHRG_AMT,
BDSSDMMGR_NFS_TRD_REV.REV_MISC_FEE_SGN,
BDSSDMMGR_NFS_TRD_REV.REV_MISC_FEE_AMT, BDSSDMMGR_NFS_TRD_REV.REV_PROD_LVL,
BDSSDMMGR_NFS_TRD_REV.REV_CNCS_LOAD_IND, BDSSDMMGR_NFS_TRD_REV.REV_PRCH_TYPE,
BDSSDMMGR_NFS_TRD_REV.REV_CMSN_SGN, BDSSDMMGR_NFS_TRD_REV.REV_CMSN_AMT,
BDSSDMMGR_NFS_TRD_REV.REV_CNCS_SGN, BDSSDMMGR_NFS_TRD_REV.REV_CNCS_AMT,
BDSSDMMGR_NFS_TRD_REV.REV_LOAD_SGN, BDSSDMMGR_NFS_TRD_REV.REV_LOAD_AMT,
BDSSDMMGR_NFS_TRD_REV.ORDR_REF_NBR, BDSSDMMGR_NFS_TRD_REV.INPT_CMSN_SGN,
BDSSDMMGR_NFS_TRD_REV.INPT_CMSN_AMT INTO [SDA 2006]
FROM BDSSDMMGR_NFS_TRD_REV
WHERE (((BDSSDMMGR_NFS_TRD_REV.BR_NBR)="PVK" Or
(BDSSDMMGR_NFS_TRD_REV.BR_NBR)="PVS"));


John Spencer said:
Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

Also, does the query refer to other queries?

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
Click to expand...
Click to expand...
 
J

John Spencer

The other thing is that the make table query is probably counting the fields
in the source table plus the fields in the destination table and in that case
you have exceeded 255 fields.


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
Hi - this query doesn't refer to other queries. SQL shown below:

SELECT BDSSDMMGR_NFS_TRD_REV.*, BDSSDMMGR_NFS_TRD_REV.CYC_DT,
BDSSDMMGR_NFS_TRD_REV.BUY_SELL_IND, BDSSDMMGR_NFS_TRD_REV.TRD_DT,
BDSSDMMGR_NFS_TRD_REV.SETL_DT, BDSSDMMGR_NFS_TRD_REV.MKT_CD,
BDSSDMMGR_NFS_TRD_REV.BLTR_CD, BDSSDMMGR_NFS_TRD_REV.CNCL_IND,
BDSSDMMGR_NFS_TRD_REV.CORR_CD, BDSSDMMGR_NFS_TRD_REV.ACCT_NBR,
BDSSDMMGR_NFS_TRD_REV.CUSIP, BDSSDMMGR_NFS_TRD_REV.BAS_PRC_CALC_CD,
BDSSDMMGR_NFS_TRD_REV.RUN_DT, BDSSDMMGR_NFS_TRD_REV.USR_REF_NBR,
BDSSDMMGR_NFS_TRD_REV.SYMB, BDSSDMMGR_NFS_TRD_REV.SCRTY_TYPE_CD,
BDSSDMMGR_NFS_TRD_REV.SCRTY_MOD_CD, BDSSDMMGR_NFS_TRD_REV.SCRTY_CALC_CD,
BDSSDMMGR_NFS_TRD_REV.RGST_REP, BDSSDMMGR_NFS_TRD_REV.SCRTY_CD,
BDSSDMMGR_NFS_TRD_REV.CMSN_ACCUM_IND, BDSSDMMGR_NFS_TRD_REV.CMSN_SCHD,
BDSSDMMGR_NFS_TRD_REV.CMSN_CNCS_CD, BDSSDMMGR_NFS_TRD_REV.QTY,
BDSSDMMGR_NFS_TRD_REV.PRC, BDSSDMMGR_NFS_TRD_REV.BAS_PRC,
BDSSDMMGR_NFS_TRD_REV.PLUS_MINUS_AMT, BDSSDMMGR_NFS_TRD_REV.PRIN_AMT,
BDSSDMMGR_NFS_TRD_REV.INT_AMT, BDSSDMMGR_NFS_TRD_REV.CMSN_AMT,
BDSSDMMGR_NFS_TRD_REV.STATE_TAX, BDSSDMMGR_NFS_TRD_REV.SCRTY_FEE,
BDSSDMMGR_NFS_TRD_REV.CERT_FEE, BDSSDMMGR_NFS_TRD_REV.PSTG,
BDSSDMMGR_NFS_TRD_REV.SRV_CHRG_MISC_FEE, BDSSDMMGR_NFS_TRD_REV.NET_AMT,
BDSSDMMGR_NFS_TRD_REV.BRKG_AMT, BDSSDMMGR_NFS_TRD_REV.CNCS_AMT,
BDSSDMMGR_NFS_TRD_REV.OTHR_EXCH_CMSN_AMT, BDSSDMMGR_NFS_TRD_REV.DESC_LINE_1,
BDSSDMMGR_NFS_TRD_REV.DESC_LINE_2, BDSSDMMGR_NFS_TRD_REV.DESC_LINE_3,
BDSSDMMGR_NFS_TRD_REV.DESC_LINE_4, BDSSDMMGR_NFS_TRD_REV.DESC_LINE_5,
BDSSDMMGR_NFS_TRD_REV.DESC_LINE_6, BDSSDMMGR_NFS_TRD_REV.DESC_LINE_7,
BDSSDMMGR_NFS_TRD_REV.DESC_LINE_8, BDSSDMMGR_NFS_TRD_REV.DESC_LINE_9,
BDSSDMMGR_NFS_TRD_REV.AUTO_LGND_1, BDSSDMMGR_NFS_TRD_REV.AUTO_LGND_2,
BDSSDMMGR_NFS_TRD_REV.RGST_REP_CD_2, BDSSDMMGR_NFS_TRD_REV.RGST_REP_CD_3,
BDSSDMMGR_NFS_TRD_REV.CMSN_PCT_DISC, BDSSDMMGR_NFS_TRD_REV.STRK_PRC,
BDSSDMMGR_NFS_TRD_REV.DUE_BILL_MULT, BDSSDMMGR_NFS_TRD_REV.LOAD_OVRD_PCT,
BDSSDMMGR_NFS_TRD_REV.ENTRY_QTY_TYPE,
BDSSDMMGR_NFS_TRD_REV.CONF_LINE_NO_FLAG,
BDSSDMMGR_NFS_TRD_REV.EXCH_LINE_NO_FLAG, BDSSDMMGR_NFS_TRD_REV.TRDG_AWAY_IND,
BDSSDMMGR_NFS_TRD_REV.BR_NBR, BDSSDMMGR_NFS_TRD_REV.MKT_SEQ,
BDSSDMMGR_NFS_TRD_REV.ADDL_MRKP, BDSSDMMGR_NFS_TRD_REV.SGNON_RGST_REP,
BDSSDMMGR_NFS_TRD_REV.OWNG_RGST_REP, BDSSDMMGR_NFS_TRD_REV.FUND_LOAD_PCT,
BDSSDMMGR_NFS_TRD_REV.PROD_CD, BDSSDMMGR_NFS_TRD_REV.TWELVEB1_IND,
BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_CD_1, BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_AMT_1,
BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_CD_2, BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_AMT_2,
BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_CD_3, BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_AMT_3,
BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_CD_4, BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_AMT_4,
BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_CD_5, BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_AMT_5,
BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_CD_6, BDSSDMMGR_NFS_TRD_REV.ADDL_FEE_AMT_6,
BDSSDMMGR_NFS_TRD_REV.REV_CLR_CHRG_SGN,
BDSSDMMGR_NFS_TRD_REV.REV_CLR_CHRG_AMT,
BDSSDMMGR_NFS_TRD_REV.REV_MISC_FEE_SGN,
BDSSDMMGR_NFS_TRD_REV.REV_MISC_FEE_AMT, BDSSDMMGR_NFS_TRD_REV.REV_PROD_LVL,
BDSSDMMGR_NFS_TRD_REV.REV_CNCS_LOAD_IND, BDSSDMMGR_NFS_TRD_REV.REV_PRCH_TYPE,
BDSSDMMGR_NFS_TRD_REV.REV_CMSN_SGN, BDSSDMMGR_NFS_TRD_REV.REV_CMSN_AMT,
BDSSDMMGR_NFS_TRD_REV.REV_CNCS_SGN, BDSSDMMGR_NFS_TRD_REV.REV_CNCS_AMT,
BDSSDMMGR_NFS_TRD_REV.REV_LOAD_SGN, BDSSDMMGR_NFS_TRD_REV.REV_LOAD_AMT,
BDSSDMMGR_NFS_TRD_REV.ORDR_REF_NBR, BDSSDMMGR_NFS_TRD_REV.INPT_CMSN_SGN,
BDSSDMMGR_NFS_TRD_REV.INPT_CMSN_AMT INTO [SDA 2006]
FROM BDSSDMMGR_NFS_TRD_REV
WHERE (((BDSSDMMGR_NFS_TRD_REV.BR_NBR)="PVK" Or
(BDSSDMMGR_NFS_TRD_REV.BR_NBR)="PVS"));


John Spencer said:
Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

Also, does the query refer to other queries?

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query with too many fields 7
Make table query: [Enter 1] AS Test 1
Make Table Query Truncating Memo Field at 255 Characters 2
Crostab query for Summary report 2
Union Query - Too Many Fields 3
export crosstab query too many fields defined 4
Passing multiple criteria to query a table 2
Select query returning too many records 2

Top