Walaaah, querynya ketinggalan satu kolom.
SELECT IIf(Not IsNull([sta1]) And IsNull([sta2]) And IsNull([sta3]),[sta1],
IIf(Not IsNull([sta1]) And Not IsNull([sta2]) And
IsNull([sta3]),[sta2],[sta3])) AS LastStatus,
IIf(Not IsNull([sta1]) And IsNull([sta2]) And
IsNull([sta3]),[tglsta1],
IIf(Not IsNull([sta1]) And Not IsNull([sta2]) And
IsNull([sta3]),[tglsta2],[tglsta3])) AS TglLastStatus,
IIf(Not IsNull([sta1]) And IsNull([sta2]) And IsNull([sta3]),1,
IIf(Not IsNull([sta1]) And Not IsNull([sta2]) And
IsNull([sta3]),2,3)) AS Status
FROM Hitung;
----- Original Message -----
From: Chandra Lesmana
To: [email protected]
Sent: Sunday, April 19, 2009 14:14
Subject: Re: [belajar-access] last status
untuk pak Johan Hung.
bisa digunakan query seperti ini.
SELECT IIf(Not IsNull([sta1]) And IsNull([sta2]) And IsNull([sta3]),[sta1],
IIf(Not IsNull([sta1]) And Not IsNull([sta2]) And
IsNull([sta3]),[sta2],[sta3])) AS LastStatus,
IIf(Not IsNull([sta1]) And IsNull([sta2]) And
IsNull([sta3]),[tglsta1],
IIf(Not IsNull([sta1]) And Not IsNull([sta2]) And
IsNull([sta3]),[tglsta2],[tglsta3])) AS DateStatus
FROM Hitung;
salam,
murid access - CL
