making Normalized tables from Non-Normalized Tables

[JrMontgom]

I have 2 tables tblAccounts linkedto tblAcctDetails using the [AccountNum] to link the tblAccounts to tblAcctDetails. (1 to Many) I messed up when creating the tblAcctDetails as it isn't normalized. I have sinced then created 3 new tables called tblMainstat and tblDetailStat. The 3rd table is a lookup table called tluBkStatNames with 4 fields BkStatID Number,FldName text,FldData Text (Either Currency or Text data type name),FldDesc Text. The new tables are linked 1:Many tblmainStat to tblDetailStat . I have gotten the data transferred from the "old" tblAccounts to "new" tblMainStat but can't figure out how to transfer the tblAcctDetail data to the "new" tblDetailStat.
Tables:
Table: tblAccounts


AccountNum Text 255
Name_of_Institution Text 64
Interest_ Rate Double 8
Maturity_Date Date/Time 8
Start_Date Date/Time 8
AcctDescription Text 60
AcctAddressId Long Integer 4
Term Long Integer 4
Active Text 1
NickName Text 255
FEIN Long Integer 4

Table: tblAcctDetail


TransId Long Integer 4
XferFrom Text 255
DatePosted Date/Time 8
Deposits Currency 8
DepCkNo Text 255
Checks Currency 8
PayToOrderOf Text 255
DateFrom Date/Time 8
DateTo Date/Time 8
IncomeType Text 75
Credits Currency 8
PrevBal Currency 8
EndBal Currency 8
PrevAsOf Date/Time 8
EndAsOf Date/Time 8
XferredTo Text 255
AmtXferredTo Currency 8
DocID Long Integer 4
XferredFrom Text 255
AmtXferredFrom Currency 8
InterestCredit Currency 8
IntCreditAcct Text 255
Posted Text 1
TotalAmt Currency (Calculated) 8
AcctNotes Text 255
CEFChecks Text 255
PrincipalAvailable Text 2
ContributorID Long Integer 4


Table: tblMainStat
TransId Long Integer 4
XferFrom Text 255
DatePosted Date/Time 8
DateFrom Date/Time 8
DateTo Date/Time 8
IncomeType Text 75
PrevAsOf Date/Time 8
EndAsOf Date/Time 8
DocID Long Integer 4
Posted Text 1
AcctNotes Text 255
ContributorID
Table: tblDetailStat

[JrMontgom]

[QUOTE=JrMontgom;271916]I have 2 tables tblAccounts linkedto tblAcctDetails using the [AccountNum] to link the tblAccounts to tblAcctDetails. (1 to Many) I messed up when creating the tblAcctDetails as it isn't normalized. I have sinced then created 3 new tables called tblMainstat and tblDetailStat. The 3rd table is a lookup table called tluBkStatNames with 4 fields BkStatID Number,FldName text,FldData Text (Either Currency or Text data type name),FldDesc Text. The new tables are linked 1:Many tblmainStat to tblDetailStat . I have gotten the data transferred from the "old" tblAccounts to "new" tblMainStat but can't figure out how to transfer the tblAcctDetail data to the "new" tblDetailStat.
Tables:
Table: tblAccounts
AccountNum Text 255
Name_of_Institution Text 64
Interest_ Rate Double 8
Maturity_Date Date/Time 8
Start_Date Date/Time 8
AcctDescription Text 60
AcctAddressId Long Integer 4
Term Long Integer 4
Active Text 1
NickName Text 255
FEIN Long Integer 4

Table: tblAcctDetail
TransId Long Integer 4
XferFrom Text 255
DatePosted Date/Time 8
Deposits Currency 8
DepCkNo Text 255
Checks Currency 8
PayToOrderOf Text 255
DateFrom Date/Time 8
DateTo Date/Time 8
IncomeType Text 75
Credits Currency 8
PrevBal Currency 8
EndBal Currency 8
PrevAsOf Date/Time 8
EndAsOf Date/Time 8
XferredTo Text 255
AmtXferredTo Currency 8
DocID Long Integer 4
XferredFrom Text 255
AmtXferredFrom Currency 8
InterestCredit Currency 8
IntCreditAcct Text 255
Posted Text 1
TotalAmt Currency (Calculated) 8
AcctNotes Text 255
CEFChecks Text 255
PrincipalAvailable Text 2
ContributorID Long Integer 4


Table: tblMainStat
TransId Long Integer 4
XferFrom Text 255
DatePosted Date/Time 8
DateFrom Date/Time 8
DateTo Date/Time 8
IncomeType Text 75
PrevAsOf Date/Time 8
EndAsOf Date/Time 8
DocID Long Integer 4
Posted Text 1
AcctNotes Text 255
ContributorID

Table: tblDetailStat

DetailID Long Integer 4
TransID Long Integer 4
DataFldName Text 255
DataCurValue Currency 8
DataTxtValue Text 255

Sorry I must have hot the wrong key when typing this long involved problem. I would appreciate a little help with creating a qqueery to transfer data from the tblAcctdetail to the new tblDetailstat using the field names in tluBkStat to link the data in tblAcctDetail to tblDetailstat. Any help at all else I have to retype the data.