ACCESS 2016, too many fields defined error

Anonymous
2015-12-29T01:14:32+00:00

My query give me an error TO MANY FIELDS DEFINED. When i count the fields i have only used 226.

What is causing this?

Thanks for any help

ed

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2017-12-22T00:15:56+00:00

Not without using subreports because once tied together they will be over 255.

Side note:  Sounds like the person who advised you is using far less of the data in the tables than you, is that so?

Was this answer helpful?

1 person found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2017-12-05T00:47:27+00:00

Not into word into the window on the web page in the link I posted.

Hmm, yep you need to bring it into a clean one again.  Note, what you downloaded was probably flat file format which means that is the way they display it not store it.

Was this answer helpful?

1 person found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2017-12-04T21:51:05+00:00

Passing on secret tip....

To format queries for easier reading, go to...

https://sqlformat.org/

Just copy in the SQL and click the Format SQL button.  (Really wish that was built into Access!)

No problem glad to help.  And hopefully, this post never disappears!

Was this answer helpful?

1 person found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2016-01-07T22:57:03+00:00

No problem... will get a message even if you reply 10 years from now! :)

Was this answer helpful?

1 person found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2015-12-29T01:41:09+00:00

Hmm, could be one of those deceptive messages because there is also a 1.024 character limit and spaces count!

That said, a query with that many fields is the *real* concern.  It sounds like an UN-normalized structure.  Why so many fields in the query?

Was this answer helpful?

1 person found this answer helpful.
0 comments

64 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-12-03T02:41:28+00:00

    Well, not the instructions that is the problem and this is not quite the same as the last issue. It's the query... you literally have a lot of fields, 250 by my count and the limit is 255.  Look...

    SELECT DISTINCT ALL_HX4.tTRK,

                    ALL_HX4.tDATE,

                    ALL_HX4.nRACE,

                    ALL_HX4.nCLA,

                    ALL_HX4.nPPO,

                    ALL_HX4.tPGM,

                    ALL_HX4.tHOR,

                    ALL_HX4.nDIST,

                    IIf(([ALL_HX4.TWK1] LIKE "[AB]*"

                         AND [ALL_HX4.TWK1] LIKE "*[567]*"),1,IIf(([ALL_HX4.TWK2] LIKE "[AB]*"

                                                                   AND [ALL_HX4.TWK2] LIKE "*[567]*"),1,IIf(([ALL_HX4.TWK3] LIKE "[AB]*"

                                                                                                             AND [ALL_HX4.TWK3] LIKE "*[567]*"),1,IIf(([ALL_HX4.TWK4] LIKE "[AB]*"

                                                                                                                                                       AND [ALL_HX4.TWK4] LIKE "*[567]*"),1,0)))) AS WWW,

                    ALL_HX4.nAE,

                    PL4LHX4.NPLS,

                    PL5LHX4.nCLch,

                    PL5LHX4.nFLD,

                    PL5LHX4.nPURS,

                    PL5LHX4.nQP,

                    ALL_HX5.tPP1TRK,

                    ALL_HX4.rTRN,

                    ALL_HX4.rJKY,

                    PL5LHX4.tTPG,

                    Format(Val(Nz([PL5LHX4.TPGM],0)),"00000000") & Right(Nz([PL5LHX4.TPGM],0),1) AS PN,

                    IIf([PL5LHX4.NTRCH]=1,"1C",IIf([PL5LHX4.NTRCH]=2,"1NC",IIf([PL5LHX4.NTRCH]=3,"2C",IIf([PL5LHX4.NTRCH]=4,"2NC",IIf([PL5LHX4.NTRCH]=5,"3C",IIf([PL5LHX4.NTRCH]=6,"3NC",IIf([PL5LHX4.NTRCH]=0,8,""))))))) AS TCC,

                    ALL_HX4.nJKCH,

                    ALL_HX5.nPP1FIN,

                    ALL_HX5.nPP2FIN,

                    ALL_HX5.nPP3FIN,

                    PL5LHX4.SOR1,

                    PL5LHX4.SOR2,

                    PL5LHX4.SOR3,

                    PL5LHX4.SF1,

                    PL5LHX4.SF2,

                    PL5LHX4.SF3,

                    ALL_HXV.tPP2TRK,

                    ALL_HXV.tPP3TRK,

                    PL5LHX4.nK,

                    PL5LHX4.LIV3,

                    PL5LHX4.SF4,

                    ALL_HXV.tPP4TRK,

                    1/2*([LIV]+[LIV1]+[LIV2]+[LIV3]) AS LT,

                    ALL_HX4.tTRN,

                    ALL_HX4.tJKY,

                    ALL_HX9.[nTSTAT1_WN%],

                    ALL_HX9.[nTSTAT8_WN%],

                    IIf([PL5LHX4.NKAT] BETWEEN 5 AND 6,1,IIf([PL5LHX4.NKAT] BETWEEN 7 AND 10,3,0)) AS KAT6,

                    PL5LHX4.nVI,

                    PL5LHX4.nJKYHST,

                    PL5LHX4.nJKYHW,

                    PL5LHX4.nTRNHW,

                    DateDiff("d",[PL4LHX4.tLdate],[twk1_date]) AS dd1,

                    PL5LHX4.nRAZOR,

                    ALL_HX9.[nTSTAT3_WN%],

                    PL5LHX4.AGO2,

                    PL5LHX4.AGO3,

                    PL5LHX4.AGO1,

                    PL5LHX4.nKAT,

                    IIf([PL5LHX4.NFAV1]=1,"A",IIf([PL5LHX4.NFAV1]=2,"B",IIf([PL5LHX4.NFAV1]=3,"C",IIf([PL5LHX4.NFAV1]=4,"D",IIf([PL5LHX4.NFAV1]=5,"F",""))))) AS FAV12,

                    IIf([PL5LHX4.NFAV2]=1,"A",IIf([PL5LHX4.NFAV2]=2,"B",IIf([PL5LHX4.NFAV2]=3,"C",IIf([PL5LHX4.NFAV2]=4,"D",IIf([PL5LHX4.NFAV2]=5,"F",""))))) AS FAV22,

                    PL4LHX4.nBUGBOY,

                    IIf([ALL_HX4.NTRN_BUZZ]>=3,3,IIf([ALL_HX4.NTRN_BUZZ]>=1,1,0)) AS TBUZZ,

                    PL4LHX4.nFIRST_TAG,

                    [ALL_HX5.NPP1PER]-[PL5LHX4.NEPR] AS PPE1,

                    [ALL_HX5.NPP2PER]-[PL5LHX4.NEPR] AS PPE2,

                    [ALL_HX5.NPP3PER]-[PL5LHX4.NEPR] AS PPE3,

                    IIf([ALL_HX5.NPP2PAC]>[ALL_HX5.NPP1PAC],[ALL_HX5.NPP2PAC],[ALL_HX5.NPP1PAC]) AS 2PA,

                    IIf([ALL_HX5.NPP2PER]>[ALL_HX5.NPP1PER],[ALL_HX5.NPP2PER],[ALL_HX5.NPP1PER]) AS 2PE,

                    PL5LHX4.rPAC,

                    PL5LHX4.rFr1,

                    PL5LHX4.rLP,

                    PL5LHX4.nFR1_DOM,

                    PL5LHX4.nFR1_ADV,

                    [2PA]-[PL5LHX4.NEPR_PAC] AS 2PAA,

                    [2PE]-[PL5LHX4.NEPR] AS 2PEE,

                    IIf([PPE1]>=[PPE2],IIf([PPE2]>=[PPE3],[PPE1]+[PPE2],[PPE1]+[PPE3]),IIf([PPE1]>=[PPE3],[PPE1]+[PPE2],[PPE2]+[PPE3])) AS TTT,

                    IIf(([ALL_HXV.NPP1FR1]>=[ALL_HXV.NPP2FR1])

                        AND ([ALL_HXV.NPP2FR1]>=[ALL_HXV.NPP3FR1])

                        AND [NLIFE_STA]>2,3,IIf(([ALL_HXV.NPP1FR1]<=[ALL_HXV.NPP2FR1])

                                                AND [ALL_HXV.NPP2FR1]<=[ALL_HXV.NPP3FR1]

                                                AND [NLIFE_STA]>2,2,0)) AS LF1,

                    IIf(([ALL_HXV.NPP1LP]>=[ALL_HXV.NPP2LP])

                        AND ([ALL_HXV.NPP2LP]>=[ALL_HXV.NPP3LP])

                        AND [NLIFE_STA]>2,3,IIf(([ALL_HXV.NPP1LP]<=[ALL_HXV.NPP2LP])

                                                AND [ALL_HXV.NPP2LP]<=[ALL_HXV.NPP3LP]

                                                AND [NLIFE_STA]>2,2,0)) AS LPP,

                    ALL_HX4.nBLOWOUT,

                    ALL_HXV.nPP1ODDS,

                    ALL_HX44.nAML,

                    IIf(([NLCLAS]=3

                         AND [NPP1FIN]=1),1,IIf(([NLCLAS]=4

                                                 AND [NPP1FIN]=1),2,0)) AS MDN,

                    [ALL_HX5.NPP1PAC]-[PL5LHX4.NEPR] AS PPA1,

                    [ALL_HX5.NPP2PAC]-[PL5LHX4.NEPR] AS PPA2,

                    [ALL_HX5.NPP3PAC]-[PL5LHX4.NEPR] AS PPA3,

                    IIf([PPA1]>=[PPA2],IIf([PPA2]>=[PPA3],[PPA1]+[PPA2],[PPA1]+[PPA3]),IIf([PPA1]>=[PPA3],[PPA1]+[PPA2],[PPA2]+[PPA3])) AS PPP,

                    ALL_HX5.n2CP1,

                    ALL_HX5.n2CP2,

                    [NPP1FR1]-60 AS FR11,

                    [NPP2FR1]-60 AS FR12,

                    [NPP3FR1]-60 AS FR13,

                    ALL_HXV.nPP1FR1,

                    ALL_HXV.nPP2FR1,

                    ALL_HXV.nPP3FR1,

                    ALL_HX5.n2CBL1,

                    ALL_HX5.n2CBL2,

                    ALL_HX5.n2CBL3,

                    PL5LHX4.rK,

                    PL4LHX4.rKMS,

                    ALL_HX5.NPP1SHF AS LP11,

                    ALL_HX5.NPP2SHF AS LP12,

                    ALL_HX5.NPP3SHF AS LP13,

                    IIf(([ALL_HX5.NPP1SHF]>=[ALL_HX5.NPP2SHF])

                        AND ([ALL_HX5.NPP2SHF]>=[ALL_HX5.NPP3SHF])

                        AND [NLIFE_STA]>2,3,IIf(([ALL_HX5.NPP1SHF]<=[ALL_HX5.NPP2SHF])

                                                AND [ALL_HX5.NPP2SHF]<=[ALL_HX5.NPP3SHF]

                                                AND [NLIFE_STA]>2,2,0)) AS ZZZ,

                    PL5LHX4.rSP,

                    ALL_HX44.nTURNS,

                    PL5LHX4.nCOURSE,

                    IIf([PL5LHX4.NCOURSE]=1,"MD",IIf([PL5LHX4.NCOURSE]=2,"MT",IIf([PL5LHX4.NCOURSE]=3,"ID",IIf([PL5LHX4.NCOURSE]=4,"IT",IIf([PL5LHX4.NCOURSE]=5,"AM",IIf([PL5LHX4.NCOURSE]=6,"STP","")))))) AS NCOURSE1,

                    IIf([PL5LHX4.NRS]=1,"F",IIf([PL5LHX4.NRS]=2,"E",IIf([PL5LHX4.NRS]=3,"P",IIf([PL5LHX4.NRS]=4,"S",IIf([PL5LHX4.NRS]=5,"R",""))))) AS RS,

                    IIf([ALL_HX5.NPP1FIN]<=(1/2*[ALL_HXV.NPP1FSZ])

                        AND (([NLFST]>=1)

                             AND (([ALL_HX5.NPP1PAC]>=[ALL_HXV.NPP1RPAC]-2)

                                  OR ([ALL_HX5.NPP1FIN]=1)

                                  OR ([ALL_HX5.NPP1PER]>=[ALL_HXV.NPP1RPER]-3))),2,0) AS LIV,

                    IIf([ALL_HX5.NPP2FIN]<=(1/2*[ALL_HXV.NPP2FSZ])

                        AND (([NLFST]>=2)

                             AND (([ALL_HX5.NPP2PAC]>=[ALL_HXV.NPP2RPAC]-2)

                                  OR ([ALL_HX5.NPP2FIN]=1)

                                  OR ([ALL_HX5.NPP2PER]>=[ALL_HXV.NPP2RPER]-3))),2,0) AS LIV1,

                    IIf([ALL_HX5.NPP3FIN]<=(1/2*[ALL_HXV.NPP3FSZ])

                        AND (([NLFST]>=3)

                             AND (([ALL_HX5.NPP3PAC]>=[ALL_HXV.NPP3RPAC]-2)

                                  OR ([ALL_HX5.NPP3FIN]=1)

                                  OR ([ALL_HX5.NPP3PER]>=[ALL_HXV.NPP3RPER]-3))),2,0) AS LIV2,

                    IIf([ALL_HX4.NWKSC]>=90,2,IIf([ALL_HX4.NWKSC]>=85,1,0)) AS WK,

                    IIf([pl5lhx4.NPACE]=1,"LON SPD",IIf([PL5LHX4.NPACE]=2,"HOT",IIf([PL5LHX4.NPACE]=3,"FAST",IIf([PL5LHX4.NPACE]=4,"NORMAL",IIf([PL5LHX4.NPACE]=5,"SOFT",""))))) AS A11,

                    ALL_HX5.n2CP3,

                    [PPP]+[TTT] AS TTP,

                    ALL_HX9.nTSTAT2_STR,

                    PL5LHX4.rHTR,

                    PL5LHX4.nUNK,

                    IIf(([LP11]<=[LP12])

                        AND ([LP12]<=[LP13])

                        AND [NLIFE_STA]>2,3,IIf(([LP11]>=[LP12])

                                                AND [LP12]>=[LP13]

                                                AND [NLIFE_STA]>2,2,0)) AS SHF,

                    IIf([PL5LHX4.NIMPROVE] BETWEEN 3 AND 4,1,IIf([PL5LHX4.NIMPROVE] BETWEEN 5 AND 15,3,0)) AS IMP,

                    IIf(([ALL_HX5.NPP1PAC]>=[ALL_HX5.NPP2PAC])

                        AND ([ALL_HX5.NPP2PAC]>=[ALL_HX5.NPP3PAC])

                        AND [NLIFE_STA]>=3,3,IIf([ALL_HX5.NPP1PAC]<=[ALL_HX5.NPP2PAC]

                                                 AND [ALL_HX5.NPP2PAC]<=[ALL_HX5.NPP3PAC]

                                                 AND [NLIFE_STA]>=3,6,IIf(([ALL_HX5.NPP1PAC]>=[ALL_HX5.NPP2PAC])

                                                                          AND ([ALL_HX5.NPP2PAC]>=[ALL_HX5.NPP4PAC])

                                                                          AND [NLIFE_STA]>=4,2,IIf(([ALL_HX5.NPP1PAC]>=[ALL_HX5.NPP3PAC])

                                                                                                   AND ([ALL_HX5.NPP3PAC]>=[ALL_HX5.NPP4PAC])

                                                                                                   AND [NLIFE_STA]>=4,2,IIf(([ALL_HX5.NPP2PAC]>=[ALL_HX5.NPP3PAC])

                                                                                                                            AND ([ALL_HX5.NPP3PAC]>=[ALL_HX5.NPP4PAC])

                                                                                                                            AND [NLIFE_STA]>=4,2,0))))) AS PPAC,

                    PL5LHX4.nIMPROVE,

                    [ALL_HX5.NPP4PER]-[PL5LHX4.NEPR] AS PPE4,

                    ALL_HX5.nPP4FIN,

                    PL5LHX4.SOR4,

                    ALL_HX44.NPOSTOT,

                    ALL_HX44.RPOSTOT,

                    IIf(([ALL_HX5.NPP1PAC]>=[ALL_HX5.NPP2PAC])

                        AND ([ALL_HX5.NPP2PAC]>=[ALL_HX5.NPP3PAC])

                        AND [NLIFE_STA]>=3,3,IIf(([ALL_HX5.NPP1PAC]>=[ALL_HX5.NPP2PAC])

                                                 AND ([ALL_HX5.NPP2PAC]>=[ALL_HX5.NPP4PAC])

                                                 AND [NLIFE_STA]>=4,2,IIf(([ALL_HX5.NPP1PAC]>=[ALL_HX5.NPP3PAC])

                                                                          AND ([ALL_HX5.NPP3PAC]>=[ALL_HX5.NPP4PAC])

                                                                          AND [NLIFE_STA]>=4,2,IIf(([ALL_HX5.NPP2PAC]>=[ALL_HX5.NPP3PAC])

                                                                                                   AND ([ALL_HX5.NPP3PAC]>=[ALL_HX5.NPP4PAC])

                                                                                                   AND [NLIFE_STA]>=4,2,IIf(([ALL_HX5.NPP1PAC]<[ALL_HX5.NPP2PAC])

                                                                                                                            AND ([ALL_HX5.NPP2PAC]<[ALL_HX5.NPP3PAC])

                                                                                                                            AND [NLIFE_STA]>=3,4,0))))) AS PEE,

                    IIf(([ALL_HX5.NPP1PER]>=[ALL_HX5.NPP2PER])

                        AND ([ALL_HX5.NPP2PER]>=[ALL_HX5.NPP3PER])

                        AND [NLIFE_STA]>=3,3,IIf(([ALL_HX5.NPP1PER]>=[ALL_HX5.NPP2PER])

                                                 AND ([ALL_HX5.NPP2PER]>=[ALL_HX5.NPP4PER])

                                                 AND [NLIFE_STA]>=4,2,IIf(([ALL_HX5.NPP1PER]>=[ALL_HX5.NPP3PER])

                                                                          AND ([ALL_HX5.NPP3PER]>=[ALL_HX5.NPP4PER])

                                                                          AND [NLIFE_STA]>=4,2,IIf(([ALL_HX5.NPP2PER]>=[ALL_HX5.NPP3PER])

                                                                                                   AND ([ALL_HX5.NPP3PER]>=[ALL_HX5.NPP4PER])

                                                                                                   AND [NLIFE_STA]>=4,2,IIf(([ALL_HX5.NPP1PER]<[ALL_HX5.NPP2PER])

                                                                                                                            AND ([ALL_HX5.NPP2PER]<[ALL_HX5.NPP3PER])

                                                                                                                            AND [NLIFE_STA]>=3,4,0))))) AS PPER,

                    IIf([ALL_HX5.NFNBL1]>=10,1,IIf([ALL_HX5.NFNBL2]>=10,2,0)) AS UT,

                    PL5LHX4.nTRNHST,

                    ALL_HXV.nPP1AGO,

                    ALL_HXV.nPP2AGO,

                    ALL_HXV.nPP3AGO,

                    ALL_HXV.nPP4AGO,

                    PL4LHX4.CHG1,

                    ALL_HX4.nLUCK,

                    IIf(([PL4LHX4.NCHG]=1

                         OR [PL4LHX4.NCHG]=5

                         OR [PL4LHX4.NCHG]=4

                         OR [PL4LHX4.NCHG]=6)

                        AND [ALL_HX5.TPP1TRK]<>[ALL_HX5.TTRK],1,0) AS CHGL,

                    ALL_HX4.nOUTLOOK,

                    [NTOPPER]-[PL5LHX4.NEPR] AS PERTOP,

                    IIf([PL5LHX4.NOUTLOOK]=1,"1VCHAULK",IIf([PL5LHX4.NOUTLOOK]=2,"2CHAULK",IIf([PL5LHX4.NOUTLOOK]=3,"3MIXED",IIf([PL5LHX4.NOUTLOOK]=4,"4VALUE",IIf([PL5LHX4.NOUTLOOK]=5,"5WOPEN",IIf([PL5LHX4.NOUTLOOK]=6,"6BOMBS","")))))) AS OLOOK,

                    ALL_HX44.rMLO,

                    ALL_HX44.tPOSSCAN,

                    IIf([ALL_HX4.NPPO]>0,[ALL_HXD.tRACECOND],0) AS RACE,

                    PL5LHX4.DIST11,

                    PL5LHX4.DIST22,

                    PL5LHX4.DIST33,

                    PL5LHX4.DIST44,

                    IIf([ALL_HX4.NDIST]<8

                        AND [NPP1DIS]<8,1,IIf([ALL_HX4.NDIST]>=8

                                              AND [NPP1DIS]>=8,1,0)) AS PAD1,

                    IIf([ALL_HX4.NDIST]<8

                        AND [NPP2DIS]<8,1,IIf([ALL_HX4.NDIST]>=8

                                              AND [NPP2DIS]>=8,1,0)) AS PAD2,

                    IIf([ALL_HX4.NDIST]<8

                        AND [NPP3DIS]<8,1,IIf([ALL_HX4.NDIST]>=8

                                              AND [NPP3DIS]>=8,1,0)) AS PAD3,

                    IIf([ALL_HX4.NDIST]<8

                        AND [NPP4DIS]<8,1,IIf([ALL_HX4.NDIST]>=8

                                              AND [NPP4DIS]>=8,1,0)) AS PAD4,

                    PL1L.tRACECOND,

                    ALL_HX4.nHAG,

                    ([NPP1FR1]-50)*10+20 AS F1,

                    ([NPP2FR1]-50)*10+20 AS F2,

                    ([NPP3FR1]-50)*10+20 AS F3,

                    ([NPP4FR1]-50)*10+20 AS F4,

                    PL1L.tCONDS,

                    ALL_HX44.nTR_TDS_STR,

                    ALL_HX44.nJK_TDS_STR,

                    ALL_HX9.[nTSTAT2_WN%],

                    ALL_HX44.nTR_TDS_WNP,

                    ALL_HX44.nJK_TDS_WNP,

                    ALL_HXV.nPP2FSZ,

                    ALL_HXV.nPP3FSZ,

                    ALL_HXV.nPP4FSZ,

                    ALL_HXV.nPP1FSZ,

                    IIf(([ALL_HXV.NPP1CSF]>=[ALL_HXV.NPP2CSF])

                        AND ([ALL_HXV.NPP2CSF]>=[ALL_HXV.NPP3CSF])

                        AND [NLIFE_STA]>=3,3,IIf(([ALL_HXV.NPP1CSF]>=[ALL_HXV.NPP2CSF])

                                                 AND ([ALL_HXV.NPP2CSF]>=[ALL_HXV.NPP4CSF])

                                                 AND [NLIFE_STA]>=4,2,IIf(([ALL_HXV.NPP1CSF]>=[ALL_HXV.NPP3CSF])

                                                                          AND ([ALL_HXV.NPP3CSF]>=[ALL_HXV.NPP4CSF])

                                                                          AND [NLIFE_STA]>=4,2,IIf(([ALL_HXV.NPP2CSF]>=[ALL_HXV.NPP3CSF])

                                                                                                   AND ([ALL_HXV.NPP3CSF]>=[ALL_HXV.NPP4CSF])

                                                                                                   AND [NLIFE_STA]>=4,2,IIf(([ALL_HXV.NPP1CSF]<[ALL_HXV.NPP2CSF])

                                                                                                                            AND ([ALL_HXV.NPP2CSF]<[ALL_HXV.NPP3CSF])

                                                                                                                            AND [NLIFE_STA]>=3,4,0))))) AS CSFF,

                    ALL_HX5.nFNBL1,

                    ALL_HX5.nFNBL2,

                    ALL_HX5.nFNBL3,

                    ALL_HX5.nFNBL4,

                    ALL_HX4.nC90,

                    ALL_HX4.nPfig,

                    ALL_HX4.rPfig,

                    ALL_HX4.rC90,

                    ALL_HXV.nPP1CSF,

                    ALL_HXV.nPP2CSF,

                    ALL_HXV.nPP3CSF,

                    ALL_HXV.nPP4CSF,

                    (50-[NPFIG])*2.5 AS PCSF,

                    ALL_HX4.nTOPPERAGO,

                    ALL_HX5.nPP1DIS,

                    ALL_HX5.nPP2DIS,

                    ALL_HX5.nPP3DIS,

                    ALL_HX5.nPP4DIS,

                    PL4LHX4.rK2,

                    ALL_HX44.nSYS4,

                    ALL_HX44.rSYS4,

                    ALL_HX4.nPSCN,

                    ALL_HX4.rPSCN,

                    PL5LHX4.tWK1,

                    PL5LHX4.tWK2,

                    PL5LHX4.tWK3,

                    PL5LHX4.tWK4,

                    ALL_HX9.tWK1_TRACK,

                    ALL_HX9.tWK2_TRACK,

                    ALL_HX9.tWK3_TRACK,

                    ALL_HX9.tWK4_TRACK,

                    ALL_HX4.nWKSC,

                    ALL_HX4.rWKSC,

                    PL4LHX4.TRC,

                    IIf(([WWW]=1

                         OR [F60] BETWEEN 1 AND 3)

                        AND [ALL_HX4.NTRCH] BETWEEN 1 AND 6,1,0) AS TTCH,

                    PL4LHX4.SORT,

                    PL4LHX4.tPLSELECTED,

                    ALL_HX44.nJK365_Starts,

                    ALL_HX44.nJK365_WinP,

                    ALL_HX44.nTR365_Starts,

                    ALL_HX44.nTR365_WinP,

                    PL5LHX4.F60,

                    ALL_HX44.rSYS2,

                    ALL_HX44.rSYS3,

                    ALL_HX44.rSYS1,

                    [NN06]+[NN07]+[NN09]+[NN10]+[NN11]+[NN12]+[NN13] AS PT,

                    [NN05]+[NN15] AS PJ,

                    ALL_HXN.nB22,

                    [NPOS14]+[NPOS16]+[NB16]+[NB17] AS GJ,

                    [NPOS04]+[NPOS30]+[NPOS32]+[NB01]+[NB12]+[NB13]+[NB22]+[NB21] AS GT,

    AND Access has internal hidden fields, so, you have too many fields.  You need to cut it back.  You *really* need to normalize this database or you are going to keep running into this issue.

    Was this answer helpful?

    0 comments