Converting calculated value into numeric value

[psamu]

I would appreciate someone help me on this. I have created a query using various fields and field called "GTPercent" with lot of calculation based on various factor, I got the percentage I want. But I just want make a table with that value I am getting an error message "Too many fields defined" although I am selecting that percentage value field and one another to make a table. Is there anyway to turnaround with this? Thanks

 

[Joe4]

I think we are going to need more details.

Are you trying to do a Make Table Query?
If so, can you post the SQL code of the query?

 

[psamu]

Thanks
SELECT LIPHMain.ID, LIPHMain.Connector, LIPHMain.FDate, LIPHMain.MIDate, LIPHMain.TransferDate, LIPHMain.PName, LIPHMain.TName, LIPHMain.ID, LIPHMain.FileNo, LIPHMain.UNumber, LIPHMain.CSS, LIPHMain.Manager, LIPHMain.AssDirector, LIPHMain.CAuditor, LIPHMain.PreviousGTotal, LIPHMain.FM1, LIPHMain.FM2, LIPHMain.FM3, LIPHMain.FM4, LIPHMain.FMS, LIPHMain.FMNote, LIPHMain.RE6, LIPHMain.RE7, LIPHMain.RE8, LIPHMain.RE9, LIPHMain.RE10, LIPHMain.RE11, LIPHMain.RE12, LIPHMain.RE13, LIPHMain.RE14, LIPHMain.RE15, LIPHMain.RE16, LIPHMain.RE17, LIPHMain.RE18, LIPHMain.RE19, LIPHMain.RE20, LIPHMain.RE21, LIPHMain.RE22, LIPHMain.RE23, LIPHMain.RE24, LIPHMain.RE25, LIPHMain.RE26, LIPHMain.RE27, LIPHMain.RE28, LIPHMain.RE29, LIPHMain.RE30, LIPHMain.RES, LIPHMain.RENote, LIPHMain.IN31, LIPHMain.IN32, LIPHMain.IN33, LIPHMain.IN34, LIPHMain.IN35, LIPHMain.IN36, LIPHMain.IN37, LIPHMain.IN38, LIPHMain.IN39, LIPHMain.IN40, LIPHMain.IN41, LIPHMain.IN42, LIPHMain.IN43, LIPHMain.IN44, LIPHMain.IN45, LIPHMain.IN46, LIPHMain.IN47, LIPHMain.IN48, LIPHMain.IN49, LIPHMain.IN50, LIPHMain.IN51, LIPHMain.IN52, LIPHMain.IN53, LIPHMain.INS, LIPHMain.INNote, LIPHMain.ML54, LIPHMain.ML55, LIPHMain.MLS, LIPHMain.MLNote, LIPHMain.LG56, LIPHMain.LG57, LIPHMain.LG58, LIPHMain.LG59, LIPHMain.LG60, LIPHMain.LG61, LIPHMain.LG62, LIPHMain.LG63, LIPHMain.LG64, LIPHMain.LG65, LIPHMain.LG66, LIPHMain.LG67, LIPHMain.LG68, LIPHMain.LG69, LIPHMain.LG70, LIPHMain.LG71, LIPHMain.LG72, LIPHMain.LG73, LIPHMain.LG74, LIPHMain.LG78, LIPHMain.LGS, LIPHMain.LGNote, LIPHMain.TF79, LIPHMain.TF80, LIPHMain.TF81, LIPHMain.TF82, LIPHMain.TF83, LIPHMain.TF84, LIPHMain.TF85, LIPHMain.TF86, LIPHMain.TF87, LIPHMain.TF88, LIPHMain.TF89, LIPHMain.TF90, LIPHMain.TFS, LIPHMain.TFNote, LIPHMain.CH91, LIPHMain.CH92, LIPHMain.CH92A, LIPHMain.CH92B, LIPHMain.CH99, LIPHMain.CHS, LIPHMain.CHNote, LIPHMain.LA100, LIPHMain.LA101, LIPHMain.LA102, LIPHMain.LA103, LIPHMain.LA104, LIPHMain.LA105, LIPHMain.LA106, LIPHMain.LA107, LIPHMain.LA108, LIPHMain.LA109, LIPHMain.LA110, LIPHMain.LA111, LIPHMain.LA112, LIPHMain.LA113, LIPHMain.LA114, LIPHMain.LA117, LIPHMain.LA118, LIPHMain.LA119, LIPHMain.LA120, LIPHMain.LA121, LIPHMain.LA122, LIPHMain.LA123, LIPHMain.LA124, LIPHMain.LA125, LIPHMain.LA126, LIPHMain.LA127, LIPHMain.LA128, LIPHMain.LA129, LIPHMain.LA130, LIPHMain.LA131, LIPHMain.LA132, LIPHMain.LA133, LIPHMain.LA134, LIPHMain.LA135, LIPHMain.LA136, LIPHMain.LA137, LIPHMain.LA138, LIPHMain.LAS, LIPHMain.LANote, LIPHMain.PI139, LIPHMain.PI140, LIPHMain.PI141, LIPHMain.PI142, LIPHMain.PI143, LIPHMain.PI144, LIPHMain.PI145, LIPHMain.PI146, LIPHMain.PI147, LIPHMain.PIS, LIPHMain.PINote, LIPHMain.OA148, LIPHMain.OA150, LIPHMain.OA151, LIPHMain.OA152, LIPHMain.OA153, LIPHMain.OA154, LIPHMain.OA155, LIPHMain.OA156, LIPHMain.OA157, LIPHMain.OA158, LIPHMain.OA159, LIPHMain.OA160, LIPHMain.OA161, LIPHMain.OA162, LIPHMain.OA163, LIPHMain.OA164, LIPHMain.OA165, LIPHMain.OA166, LIPHMain.OA167, LIPHMain.OA168, LIPHMain.OA169, LIPHMain.OA170, LIPHMain.OA171, LIPHMain.OA172, LIPHMain.OA173, LIPHMain.OA174, LIPHMain.OA175, LIPHMain.OA176, LIPHMain.OAS, LIPHMain.OANote, LIPHMain.CL177, LIPHMain.CL178, LIPHMain.CL179, LIPHMain.CL180, LIPHMain.CL181, LIPHMain.CL182, LIPHMain.CL183, LIPHMain.CL184, LIPHMain.CL185, LIPHMain.CL186, LIPHMain.CL187, LIPHMain.CL188, LIPHMain.CL189, LIPHMain.CL190, LIPHMain.CL191, LIPHMain.CL192, LIPHMain.CL193, LIPHMain.CL194, LIPHMain.CL195, LIPHMain.CL196, LIPHMain.CL197, LIPHMain.CL198, LIPHMain.CL199, LIPHMain.CL200, LIPHMain.CL201, LIPHMain.CL202, LIPHMain.CL203, LIPHMain.CL204, LIPHMain.CLS, LIPHMain.CLNote, LIPHMain.DueDate, LIPHMain.Notes, LIPHMain.[Final Note], IIF([LIPHMain]![FMS]=Yes,

([LIPHMain]![FM1]*[LIPHMainScore]![FM1])*-1+
([LIPHMain]![FM2]*[LIPHMainScore]![FM2])*-1+
([LIPHMain]![FM3]*[LIPHMainScore]![FM3])*-1+
([LIPHMain]![FM4]*[LIPHMainScore]![FM4])*-1,0) AS FMscore, IIF([LIPHMain]![RES]=Yes,

([LIPHMain]![RE6]*[LIPHMainScore]![RE6])*-1+
([LIPHMain]![RE7]*[LIPHMainScore]![RE7])*-1+
([LIPHMain]![RE8]*[LIPHMainScore]![RE8])*-1+
([LIPHMain]![RE9]*[LIPHMainScore]![RE9])*-1+
([LIPHMain]![RE10]*[LIPHMainScore]![RE10])*-1+
([LIPHMain]![RE11]*[LIPHMainScore]![RE11])*-1+
([LIPHMain]![RE12]*[LIPHMainScore]![RE12])*-1+
([LIPHMain]![RE13]*[LIPHMainScore]![RE13])*-1+
([LIPHMain]![RE14]*[LIPHMainScore]![RE14])*-1+
([LIPHMain]![RE15]*[LIPHMainScore]![RE15])*-1+
([LIPHMain]![RE16]*[LIPHMainScore]![RE16])*-1+
([LIPHMain]![RE17]*[LIPHMainScore]![RE17])*-1+
([LIPHMain]![RE18]*[LIPHMainScore]![RE18])*-1+
([LIPHMain]![RE19]*[LIPHMainScore]![RE19])*-1+
([LIPHMain]![RE20]*[LIPHMainScore]![RE20])*-1+
([LIPHMain]![RE21]*[LIPHMainScore]![RE21])*-1+
([LIPHMain]![RE22]*[LIPHMainScore]![RE22])*-1+
([LIPHMain]![RE23]*[LIPHMainScore]![RE23])*-1+
([LIPHMain]![RE24]*[LIPHMainScore]![RE24])*-1+
([LIPHMain]![RE25]*[LIPHMainScore]![RE25])*-1+
([LIPHMain]![RE26]*[LIPHMainScore]![RE26])*-1+
([LIPHMain]![RE27]*[LIPHMainScore]![RE27])*-1+
([LIPHMain]![RE28]*[LIPHMainScore]![RE28])*-1+
([LIPHMain]![RE29]*[LIPHMainScore]![RE29])*-1+
([LIPHMain]![RE30]*[LIPHMainScore]![RE30])*-1,0) AS REscore, IIF([LIPHMain]![INS]=Yes,

([LIPHMain]![IN31]*[LIPHMainScore]![IN31])*-1+
([LIPHMain]![IN32]*[LIPHMainScore]![IN32])*-1+
([LIPHMain]![IN33]*[LIPHMainScore]![IN33])*-1+
([LIPHMain]![IN34]*[LIPHMainScore]![IN34])*-1+
([LIPHMain]![IN35]*[LIPHMainScore]![IN35])*-1+
([LIPHMain]![IN36]*[LIPHMainScore]![IN36])*-1+
([LIPHMain]![IN37]*[LIPHMainScore]![IN37])*-1+
([LIPHMain]![IN38]*[LIPHMainScore]![IN38])*-1+
([LIPHMain]![IN39]*[LIPHMainScore]![IN39])*-1+
([LIPHMain]![IN40]*[LIPHMainScore]![IN40])*-1+
([LIPHMain]![IN41]*[LIPHMainScore]![IN41])*-1+
([LIPHMain]![IN42]*[LIPHMainScore]![IN42])*-1+
([LIPHMain]![IN43]*[LIPHMainScore]![IN43])*-1+
([LIPHMain]![IN44]*[LIPHMainScore]![IN44])*-1+
([LIPHMain]![IN45]*[LIPHMainScore]![IN45])*-1+
([LIPHMain]![IN46]*[LIPHMainScore]![IN46])*-1+
([LIPHMain]![IN47]*[LIPHMainScore]![IN47])*-1+
([LIPHMain]![IN48]*[LIPHMainScore]![IN48])*-1+
([LIPHMain]![IN49]*[LIPHMainScore]![IN49])*-1+
([LIPHMain]![IN50]*[LIPHMainScore]![IN50])*-1+
([LIPHMain]![IN51]*[LIPHMainScore]![IN51])*-1+
([LIPHMain]![IN52]*[LIPHMainScore]![IN52])*-1+
([LIPHMain]![IN53]*[LIPHMainScore]![IN53])*-1,0) AS INscore, IIF([LIPHMain]![MLS]=Yes,

([LIPHMain]![ML54]*[LIPHMainScore]![ML54])*-1+
([LIPHMain]![ML55]*[LIPHMainScore]![ML55])*-1,0) AS MLscore, IIF([LIPHMain]![LGS]=Yes,

([LIPHMain]![LG56]*[LIPHMainScore]![LG56])*-1+
([LIPHMain]![LG57]*[LIPHMainScore]![LG57])*-1+
([LIPHMain]![LG58]*[LIPHMainScore]![LG58])*-1+
([LIPHMain]![LG59]*[LIPHMainScore]![LG59])*-1+
([LIPHMain]![LG60]*[LIPHMainScore]![LG60])*-1+
([LIPHMain]![LG61]*[LIPHMainScore]![LG61])*-1+
([LIPHMain]![LG62]*[LIPHMainScore]![LG62])*-1+
([LIPHMain]![LG63]*[LIPHMainScore]![LG63])*-1+
([LIPHMain]![LG64]*[LIPHMainScore]![LG64])*-1+
([LIPHMain]![LG65]*[LIPHMainScore]![LG65])*-1+
([LIPHMain]![LG66]*[LIPHMainScore]![LG66])*-1+
([LIPHMain]![LG67]*[LIPHMainScore]![LG67])*-1+
([LIPHMain]![LG68]*[LIPHMainScore]![LG68])*-1+
([LIPHMain]![LG69]*[LIPHMainScore]![LG69])*-1+
([LIPHMain]![LG70]*[LIPHMainScore]![LG70])*-1+
([LIPHMain]![LG71]*[LIPHMainScore]![LG71])*-1+
([LIPHMain]![LG72]*[LIPHMainScore]![LG72])*-1+
([LIPHMain]![LG73]*[LIPHMainScore]![LG73])*-1+
([LIPHMain]![LG74]*[LIPHMainScore]![LG74])*-1+
([LIPHMain]![LG78]*[LIPHMainScore]![LG78])*-1,0) AS LGscore, IIF([LIPHMain]![TFS]=Yes,

([LIPHMain]![TF79]*[LIPHMainScore]![TF79])*-1+
([LIPHMain]![TF80]*[LIPHMainScore]![TF80])*-1+
([LIPHMain]![TF81]*[LIPHMainScore]![TF81])*-1+
([LIPHMain]![TF82]*[LIPHMainScore]![TF82])*-1+
([LIPHMain]![TF83]*[LIPHMainScore]![TF83])*-1+
([LIPHMain]![TF84]*[LIPHMainScore]![TF84])*-1+
([LIPHMain]![TF85]*[LIPHMainScore]![TF85])*-1+
([LIPHMain]![TF86]*[LIPHMainScore]![TF86])*-1+
([LIPHMain]![TF87]*[LIPHMainScore]![TF87])*-1+
([LIPHMain]![TF88]*[LIPHMainScore]![TF88])*-1+
([LIPHMain]![TF89]*[LIPHMainScore]![TF89])*-1+
([LIPHMain]![TF90]*[LIPHMainScore]![TF90])*-1,0) AS TFscore, IIF([LIPHMain]![CHS]=Yes,

([LIPHMain]![CH91]*[LIPHMainScore]![CH91])*-1+
([LIPHMain]![CH92]*[LIPHMainScore]![CH92])*-1+
([LIPHMain]![CH92A]*[LIPHMainScore]![CH92A])*-1+
([LIPHMain]![CH92B]*[LIPHMainScore]![CH92B])*-1+
([LIPHMain]![CH99]*[LIPHMainScore]![CH99])*-1,0) AS CHScore, IIF([LIPHMain]![LAS]=Yes,

([LIPHMain]![LA100]*[LIPHMainScore]![LA100])*-1+
([LIPHMain]![LA101]*[LIPHMainScore]![LA101])*-1+
([LIPHMain]![LA102]*[LIPHMainScore]![LA102])*-1+
([LIPHMain]![LA103]*[LIPHMainScore]![LA103])*-1+
([LIPHMain]![LA104]*[LIPHMainScore]![LA104])*-1+
([LIPHMain]![LA105]*[LIPHMainScore]![LA105])*-1+
([LIPHMain]![LA106]*[LIPHMainScore]![LA106])*-1+
([LIPHMain]![LA107]*[LIPHMainScore]![LA107])*-1+
([LIPHMain]![LA108]*[LIPHMainScore]![LA108])*-1+
([LIPHMain]![LA109]*[LIPHMainScore]![LA109])*-1+
([LIPHMain]![LA110]*[LIPHMainScore]![LA110])*-1+
([LIPHMain]![LA111]*[LIPHMainScore]![LA111])*-1+
([LIPHMain]![LA112]*[LIPHMainScore]![LA112])*-1+
([LIPHMain]![LA113]*[LIPHMainScore]![LA113])*-1+
([LIPHMain]![LA114]*[LIPHMainScore]![LA114])*-1+
([LIPHMain]![LA117]*[LIPHMainScore]![LA117])*-1+
([LIPHMain]![LA118]*[LIPHMainScore]![LA118])*-1+
([LIPHMain]![LA119]*[LIPHMainScore]![LA119])*-1+
([LIPHMain]![LA120]*[LIPHMainScore]![LA120])*-1+
([LIPHMain]![LA121]*[LIPHMainScore]![LA121])*-1+
([LIPHMain]![LA122]*[LIPHMainScore]![LA122])*-1+
([LIPHMain]![LA123]*[LIPHMainScore]![LA123])*-1+
([LIPHMain]![LA124]*[LIPHMainScore]![LA124])*-1+
([LIPHMain]![LA125]*[LIPHMainScore]![LA125])*-1+
([LIPHMain]![LA126]*[LIPHMainScore]![LA126])*-1+
([LIPHMain]![LA127]*[LIPHMainScore]![LA127])*-1+
([LIPHMain]![LA128]*[LIPHMainScore]![LA128])*-1+
([LIPHMain]![LA129]*[LIPHMainScore]![LA129])*-1+
([LIPHMain]![LA130]*[LIPHMainScore]![LA130])*-1+
([LIPHMain]![LA131]*[LIPHMainScore]![LA131])*-1+
([LIPHMain]![LA132]*[LIPHMainScore]![LA132])*-1+
([LIPHMain]![LA133]*[LIPHMainScore]![LA133])*-1+
([LIPHMain]![LA134]*[LIPHMainScore]![LA134])*-1+
([LIPHMain]![LA135]*[LIPHMainScore]![LA135])*-1+
([LIPHMain]![LA136]*[LIPHMainScore]![LA136])*-1+
([LIPHMain]![LA137]*[LIPHMainScore]![LA137])*-1+
([LIPHMain]![LA138]*[LIPHMainScore]![LA138])*-1,0) AS LAScore, IIF([LIPHMain]![PIS]=Yes,

([LIPHMain]![PI139]*[LIPHMainScore]![PI139])*-1+
([LIPHMain]![PI140]*[LIPHMainScore]![PI140])*-1+
([LIPHMain]![PI141]*[LIPHMainScore]![PI141])*-1+
([LIPHMain]![PI142]*[LIPHMainScore]![PI142])*-1+
([LIPHMain]![PI143]*[LIPHMainScore]![PI143])*-1+
([LIPHMain]![PI144]*[LIPHMainScore]![PI144])*-1+
([LIPHMain]![PI145]*[LIPHMainScore]![PI145])*-1+
([LIPHMain]![PI146]*[LIPHMainScore]![PI146])*-1+
([LIPHMain]![PI147]*[LIPHMainScore]![PI147])*-1,0) AS PIScore, IIF([LIPHMain]![OAS]=Yes,

([LIPHMain]![OA148]*[LIPHMainScore]![OA148])*-1+
([LIPHMain]![OA150]*[LIPHMainScore]![OA150])*-1+
([LIPHMain]![OA151]*[LIPHMainScore]![OA151])*-1+
([LIPHMain]![OA152]*[LIPHMainScore]![OA152])*-1+
([LIPHMain]![OA153]*[LIPHMainScore]![OA153])*-1+
([LIPHMain]![OA154]*[LIPHMainScore]![OA154])*-1+
([LIPHMain]![OA155]*[LIPHMainScore]![OA155])*-1+
([LIPHMain]![OA156]*[LIPHMainScore]![OA156])*-1+
([LIPHMain]![OA157]*[LIPHMainScore]![OA157])*-1+
([LIPHMain]![OA158]*[LIPHMainScore]![OA158])*-1+
([LIPHMain]![OA159]*[LIPHMainScore]![OA159])*-1+
([LIPHMain]![OA160]*[LIPHMainScore]![OA160])*-1+
([LIPHMain]![OA161]*[LIPHMainScore]![OA161])*-1+
([LIPHMain]![OA162]*[LIPHMainScore]![OA162])*-1+
([LIPHMain]![OA163]*[LIPHMainScore]![OA163])*-1+
([LIPHMain]![OA164]*[LIPHMainScore]![OA164])*-1+
([LIPHMain]![OA165]*[LIPHMainScore]![OA165])*-1+
([LIPHMain]![OA166]*[LIPHMainScore]![OA166])*-1+
([LIPHMain]![OA167]*[LIPHMainScore]![OA167])*-1+
([LIPHMain]![OA168]*[LIPHMainScore]![OA168])*-1+
([LIPHMain]![OA169]*[LIPHMainScore]![OA169])*-1+
([LIPHMain]![OA170]*[LIPHMainScore]![OA170])*-1+
([LIPHMain]![OA171]*[LIPHMainScore]![OA171])*-1+
([LIPHMain]![OA172]*[LIPHMainScore]![OA172])*-1+
([LIPHMain]![OA173]*[LIPHMainScore]![OA173])*-1+
([LIPHMain]![OA174]*[LIPHMainScore]![OA174])*-1+
([LIPHMain]![OA175]*[LIPHMainScore]![OA175])*-1+
([LIPHMain]![OA176]*[LIPHMainScore]![OA176])*-1,0) AS OAScore, IIF([LIPHMain]![CLS]=Yes,

([LIPHMain]![CL177]*[LIPHMainScore]![CL177])*-1+
([LIPHMain]![CL178]*[LIPHMainScore]![CL178])*-1+
([LIPHMain]![CL179]*[LIPHMainScore]![CL179])*-1+
([LIPHMain]![CL180]*[LIPHMainScore]![CL180])*-1+
([LIPHMain]![CL181]*[LIPHMainScore]![CL181])*-1+
([LIPHMain]![CL182]*[LIPHMainScore]![CL182])*-1+
([LIPHMain]![CL183]*[LIPHMainScore]![CL183])*-1+
([LIPHMain]![CL184]*[LIPHMainScore]![CL184])*-1+
([LIPHMain]![CL185]*[LIPHMainScore]![CL185])*-1+
([LIPHMain]![CL186]*[LIPHMainScore]![CL186])*-1+
([LIPHMain]![CL187]*[LIPHMainScore]![CL187])*-1+
([LIPHMain]![CL188]*[LIPHMainScore]![CL188])*-1+
([LIPHMain]![CL189]*[LIPHMainScore]![CL189])*-1+
([LIPHMain]![CL190]*[LIPHMainScore]![CL190])*-1+
([LIPHMain]![CL191]*[LIPHMainScore]![CL191])*-1+
([LIPHMain]![CL192]*[LIPHMainScore]![CL192])*-1+
([LIPHMain]![CL193]*[LIPHMainScore]![CL193])*-1+
([LIPHMain]![CL194]*[LIPHMainScore]![CL194])*-1+
([LIPHMain]![CL195]*[LIPHMainScore]![CL195])*-1+
([LIPHMain]![CL196]*[LIPHMainScore]![CL196])*-1+
([LIPHMain]![CL197]*[LIPHMainScore]![CL197])*-1+
([LIPHMain]![CL198]*[LIPHMainScore]![CL198])*-1+
([LIPHMain]![CL199]*[LIPHMainScore]![CL199])*-1+
([LIPHMain]![CL200]*[LIPHMainScore]![CL200])*-1+
([LIPHMain]![CL201]*[LIPHMainScore]![CL201])*-1+
([LIPHMain]![CL202]*[LIPHMainScore]![CL202])*-1+
([LIPHMain]![CL203]*[LIPHMainScore]![CL203])*-1+
([LIPHMain]![CL204]*[LIPHMainScore]![CL204])*-1,0) AS CLScore
FROM LIPHMainScore INNER JOIN LIPHMain ON LIPHMainScore.Connector = LIPHMain.Connector;

 

[Joe4]

I thought you were trying to make a Make Table query. This looks like a SELECT query to me.

I have to question your table design. You should very rarely ever have that many fields in a table. Usually, if you have that many, it is indicative that you have a design issue and your database is not normalized. That is going to make it very difficult to work with.

Note that Access tables can only hold 256 fields. I don't think you are quite there yet, but getting close.

I would also recommend changing any long calculations to User Defined Functions.

 

[psamu]

Thanks. I have close to 245 fields, the reason I created like that I want all the fields in a form. I didn't know alternative way. Is there any? Now this moment I want to export this query into a table as values. but it says too many fields. but, query runs. Thank you for your time.

 

[Joe4]

It sounds like you are bumping up against some sort of limitation.
I think you may need to look at re-designing your tables so you do not have so many fields. Note that you should not have multiple fields that hold the same type of information in a table.

For example, if you had fields like LA1, LA2, LA3, LA4, ... LA10 in a table, that is not good table design.
Instead, you should have 10 records with two fields, in lieu of these ten with names something like ScoreCode, ScoreValue, i.e.

ScoreCode    ScoreValue
LA1                ...
LA2                ...
LA3                ...
...                ...
LA10               ...

That will greatly decrease the number of fields that you have (and increase the records, which is OK, if you have designed things properly).

 

[psamu]

Thanks for your input. I understand what you are saying, LA1, LA2, LA3, LA4, ... LA10 these fields are Yes or No value fields. Quality staff check files, and verifying all items. Each items they want to see on the form, and various names not like LA1, LA2, LA3, LA4, ... LA10(For Eg. LA1 means Family Members, LA2, Income Certificate etc.). Can I split the table into two and is that possible to create a form with two tab each hold about 100 fields? Thanks for your time.

 

[Joe4]

In regards to your question, I am a little unclear of what you ultimate goal here is.
Are you trying to create a form?
Export the data?
Create a new table off of this data?

 

[psamu]

I am trying to export data into a table.

 

[Joe4]

A table located where?
Excel? SQL? Oracle? A different Access database?