D
Duncs
I have an append query that adds data to a table. One of the fields that is
appended may be blank, in the original table. What I want to do, is if the
original data field is blank, fill the destination field with a value.
My query has the following SQL code:
INSERT INTO tblFirstActions ( MPAN, LatestDate, SA, DebtAmt, RR, QueuedSA,
SATotalDebt, SADebtRR )
SELECT tblFirstDebtmessage_All.fldMPAN, tblFirstDebtmessage_All.FirstDate,
tblFirstDebtmessage_All.fldStatus, tblFirstDebtmessage_All.fldSATotalDebt,
tblFirstDebtmessage_All.fldSADebtRecoveryRate,
tblFirstDebtmessage_All.FirstOffldQueuedSAID,
tblFirstDebtmessage_All.FirstOffldSATotalDebt,
tblFirstDebtmessage_All.FirstOffldSADebtRecoveryRate
FROM tblFirstDebtmessage_All;
The original field that may be blank is "tblFirstDebtmessage_All.fldStatus"
but if it is, I want the destination field "SA" to contain the text "Dummy".
Is this possible, or would I need a separate update query to go through the
tabel and convert any blanks to the value I need?
Many thanks
Duncs
appended may be blank, in the original table. What I want to do, is if the
original data field is blank, fill the destination field with a value.
My query has the following SQL code:
INSERT INTO tblFirstActions ( MPAN, LatestDate, SA, DebtAmt, RR, QueuedSA,
SATotalDebt, SADebtRR )
SELECT tblFirstDebtmessage_All.fldMPAN, tblFirstDebtmessage_All.FirstDate,
tblFirstDebtmessage_All.fldStatus, tblFirstDebtmessage_All.fldSATotalDebt,
tblFirstDebtmessage_All.fldSADebtRecoveryRate,
tblFirstDebtmessage_All.FirstOffldQueuedSAID,
tblFirstDebtmessage_All.FirstOffldSATotalDebt,
tblFirstDebtmessage_All.FirstOffldSADebtRecoveryRate
FROM tblFirstDebtmessage_All;
The original field that may be blank is "tblFirstDebtmessage_All.fldStatus"
but if it is, I want the destination field "SA" to contain the text "Dummy".
Is this possible, or would I need a separate update query to go through the
tabel and convert any blanks to the value I need?
Many thanks
Duncs