G
Guest
I am trying to fit the following in code behind a form button:
SELECT tbl_MasterPop_new.[Loan Acct #], tbl_MasterPop_new.PopEnterDt,
tbl_MasterPop_new.Status, "x" AS prevsta, tbl_MasterPop_new.[Buying Center
#], tbl_MasterPop_new.[Division Name], tbl_MasterPop_new.[Region Name],
tbl_MasterPop_new.[Group Name], tbl_MasterPop_new.[Collection Center Name] AS
Expr1, tbl_MasterPop_new.[Distribution Channel], tbl_MasterPop_new.[New
Institution Name], tbl_MasterPop_new.[Origination Channel],
tbl_MasterPop_new.[Sub Channel], tbl_MasterPop_new.[Short Name],
tbl_MasterPop_new.[Loan Status], tbl_MasterPop_new.[Contract Date],
tbl_MasterPop_new.[Mat date], tbl_MasterPop_new.[Next Pmt Due Date],
tbl_MasterPop_new.[Payoff Date], tbl_MasterPop_new.[Paid Off?],
tbl_MasterPop_new.[Nbr of Reg Pmts Made], tbl_MasterPop_new.[# Reg Pmts
Remaining], tbl_MasterPop_new.[Pmt Scd Monthly Pmt Amt],
tbl_MasterPop_new.[Last Pmt Date], tbl_MasterPop_new.[Last Pmt Amt],
tbl_MasterPop_new.[Amended?], tbl_MasterPop_new.[Amended This Mo?],
tbl_MasterPop_new.[DEL Group], tbl_MasterPop_new.[Days Delinquent],
tbl_MasterPop_new.[Tot Past Due Pmts $], tbl_MasterPop_new.[Principal
Balance], tbl_MasterPop_new.[Val Reserve Dollar Amt],
tbl_MasterPop_new.NETBAL, tbl_MasterPop_new.[Ext?],
tbl_MasterPop_new.[Extended This Mo?], tbl_MasterPop_new.[Payoff Dollar Amt],
tbl_MasterPop_new.[Flat Void Mth of Orig], tbl_MasterPop_new.[Active BK Flag
Date], tbl_MasterPop_new.[Active BK Flag], tbl_MasterPop_new.[Inventory
Status], tbl_MasterPop_new.[Charge Off Principal], tbl_MasterPop_new.[Chg Off
Type], tbl_MasterPop_new.[CHG OFF Date], tbl_MasterPop_new.[Cure Letter
Date], tbl_MasterPop_new.[Skip Active Date], tbl_MasterPop_new.[Skip
Completion Date], tbl_MasterPop_new.[Skip Completion Sts],
tbl_MasterPop_new.[Redeemed Date], tbl_MasterPop_new.[Entered Date],
tbl_MasterPop_new.[Repo Ordered Date], tbl_MasterPop_new.[Active Inactive
Flag] INTO Tbl_MasterPop
FROM tbl_MasterPop_new;
how do I break this into several lines, as it does not all fit into one line?
Thanks in advance,
geebee
SELECT tbl_MasterPop_new.[Loan Acct #], tbl_MasterPop_new.PopEnterDt,
tbl_MasterPop_new.Status, "x" AS prevsta, tbl_MasterPop_new.[Buying Center
#], tbl_MasterPop_new.[Division Name], tbl_MasterPop_new.[Region Name],
tbl_MasterPop_new.[Group Name], tbl_MasterPop_new.[Collection Center Name] AS
Expr1, tbl_MasterPop_new.[Distribution Channel], tbl_MasterPop_new.[New
Institution Name], tbl_MasterPop_new.[Origination Channel],
tbl_MasterPop_new.[Sub Channel], tbl_MasterPop_new.[Short Name],
tbl_MasterPop_new.[Loan Status], tbl_MasterPop_new.[Contract Date],
tbl_MasterPop_new.[Mat date], tbl_MasterPop_new.[Next Pmt Due Date],
tbl_MasterPop_new.[Payoff Date], tbl_MasterPop_new.[Paid Off?],
tbl_MasterPop_new.[Nbr of Reg Pmts Made], tbl_MasterPop_new.[# Reg Pmts
Remaining], tbl_MasterPop_new.[Pmt Scd Monthly Pmt Amt],
tbl_MasterPop_new.[Last Pmt Date], tbl_MasterPop_new.[Last Pmt Amt],
tbl_MasterPop_new.[Amended?], tbl_MasterPop_new.[Amended This Mo?],
tbl_MasterPop_new.[DEL Group], tbl_MasterPop_new.[Days Delinquent],
tbl_MasterPop_new.[Tot Past Due Pmts $], tbl_MasterPop_new.[Principal
Balance], tbl_MasterPop_new.[Val Reserve Dollar Amt],
tbl_MasterPop_new.NETBAL, tbl_MasterPop_new.[Ext?],
tbl_MasterPop_new.[Extended This Mo?], tbl_MasterPop_new.[Payoff Dollar Amt],
tbl_MasterPop_new.[Flat Void Mth of Orig], tbl_MasterPop_new.[Active BK Flag
Date], tbl_MasterPop_new.[Active BK Flag], tbl_MasterPop_new.[Inventory
Status], tbl_MasterPop_new.[Charge Off Principal], tbl_MasterPop_new.[Chg Off
Type], tbl_MasterPop_new.[CHG OFF Date], tbl_MasterPop_new.[Cure Letter
Date], tbl_MasterPop_new.[Skip Active Date], tbl_MasterPop_new.[Skip
Completion Date], tbl_MasterPop_new.[Skip Completion Sts],
tbl_MasterPop_new.[Redeemed Date], tbl_MasterPop_new.[Entered Date],
tbl_MasterPop_new.[Repo Ordered Date], tbl_MasterPop_new.[Active Inactive
Flag] INTO Tbl_MasterPop
FROM tbl_MasterPop_new;
how do I break this into several lines, as it does not all fit into one line?
Thanks in advance,
geebee