terima kasih banyak Pak Chandra atas pencerahannya. Thanks
2009/4/19 Chandra Lesmana <[email protected]>: > > > 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 > >
