G
geebee
I have the following query:
SELECT Tbl_archive.[Loan Acct #], Tbl_archive.status AS thurs_status,
DLookUp("[status]","tbl_archive","[PopEnterDt] = #" & Date()-2 & "# AND [loan
acct #] = " & [loan acct #]) AS wed_status, IIf([wed_status]<>"chargeoff" And
[thurs_status]="chargeoff" And [CHG OFF DATE] Is Not
Null,"CHARGEOFF",IIf([WED_STATUS]<>"BK" And [THURS_STATUS]="BK" And [ACTIVE
INACTIVE FLAG]="A","BK",IIf([WED_STATUS]<>"PAIDOFF" And
[THURS_STATUS]="PAIDOFF" And [PAID OFF?]=1 And [PAYOFF DATE] Is Not
Null,"PAIDOFF",IIf([WED_STATUS]<>"REPO" And [THURS_STATUS]="REPO" And
[INVENTORY STATUS] In ("IN","SO"),"REPO",IIf([WED_STATUS] Like "PASTDUE*" And
[THURS_STATUS]="CURRENT" And ([AMENDED THIS MO?]=1 Or [EXTENDED THIS MO?]=1)
And [PAID OFF?]=0 And [ACTIVE INACTIVE FLAG]="I","CURRENT BKAMD
DEF",IIf([WED_STATUS] Like "PASTDUE*" And [THURS_STATUS]="CURRENT" And
([AMENDED THIS MO?]=0 Or [EXTENDED THIS MO?]=0) And [PAID OFF?]=0,"CURRENT
PAID",IIf([WED_STATUS] Like "PASTDUE*" And [THURS_STATUS]="CURRENT" And
([AMENDED THIS MO?]=1 Or [EXTENDED THIS MO?]=1) And [PAID OFF?]=0,"CURRENT
AMD DEFR",""))))))) AS possible_pasted, Tbl_archive.[chg off date],
Tbl_archive.[active bk flag], Tbl_archive.[active inactive flag],
Tbl_archive.[paid off?], Tbl_archive.[payoff date], Tbl_archive.[inventory
status], Tbl_archive.[amended this mo?], Tbl_archive.[extended this mo?]
FROM Tbl_archive
WHERE (((Tbl_archive.PopEnterDt)=Date()-1));
I need to change it to an UPDATE query, in which the [pasted] value for each
record is updated by the value of [possible_pasted] for each row. ALL in
tbl_archive.
thanks in advance,
geebee
SELECT Tbl_archive.[Loan Acct #], Tbl_archive.status AS thurs_status,
DLookUp("[status]","tbl_archive","[PopEnterDt] = #" & Date()-2 & "# AND [loan
acct #] = " & [loan acct #]) AS wed_status, IIf([wed_status]<>"chargeoff" And
[thurs_status]="chargeoff" And [CHG OFF DATE] Is Not
Null,"CHARGEOFF",IIf([WED_STATUS]<>"BK" And [THURS_STATUS]="BK" And [ACTIVE
INACTIVE FLAG]="A","BK",IIf([WED_STATUS]<>"PAIDOFF" And
[THURS_STATUS]="PAIDOFF" And [PAID OFF?]=1 And [PAYOFF DATE] Is Not
Null,"PAIDOFF",IIf([WED_STATUS]<>"REPO" And [THURS_STATUS]="REPO" And
[INVENTORY STATUS] In ("IN","SO"),"REPO",IIf([WED_STATUS] Like "PASTDUE*" And
[THURS_STATUS]="CURRENT" And ([AMENDED THIS MO?]=1 Or [EXTENDED THIS MO?]=1)
And [PAID OFF?]=0 And [ACTIVE INACTIVE FLAG]="I","CURRENT BKAMD
DEF",IIf([WED_STATUS] Like "PASTDUE*" And [THURS_STATUS]="CURRENT" And
([AMENDED THIS MO?]=0 Or [EXTENDED THIS MO?]=0) And [PAID OFF?]=0,"CURRENT
PAID",IIf([WED_STATUS] Like "PASTDUE*" And [THURS_STATUS]="CURRENT" And
([AMENDED THIS MO?]=1 Or [EXTENDED THIS MO?]=1) And [PAID OFF?]=0,"CURRENT
AMD DEFR",""))))))) AS possible_pasted, Tbl_archive.[chg off date],
Tbl_archive.[active bk flag], Tbl_archive.[active inactive flag],
Tbl_archive.[paid off?], Tbl_archive.[payoff date], Tbl_archive.[inventory
status], Tbl_archive.[amended this mo?], Tbl_archive.[extended this mo?]
FROM Tbl_archive
WHERE (((Tbl_archive.PopEnterDt)=Date()-1));
I need to change it to an UPDATE query, in which the [pasted] value for each
record is updated by the value of [possible_pasted] for each row. ALL in
tbl_archive.
thanks in advance,
geebee