On 23 Apr 2009 at 19:49, Murid Belajar Access wrote: > di EXCEL digunakan: > EXACT(text1,text2) > Compares two text strings and returns TRUE if they are exactly the same, > FALSE otherwise. EXACT is case-sensitive but ignores formatting differences. > Use EXACT to test text being entered into a document. > > di VBA gunakan: > StrComp Function > StrComp(string1, string2[, compare]) > Returns a Variant (Integer) indicating the result of a string > comparison. > string1 is less than string2 -1 > string1 is equal to string2 0 > string1 is greater than string2 1 > string1 or string2 is Null Null >
alhamdulillah, sangat berguna trims banyak mas murid :D tadi sempat kepikiran apa pakai kombinasi instr, instrrev dan len misal table T ref uji abcd abcd abcdefg abcd 1001 1001 00100 0100 0 0 0 dengan query sbb : SELECT T.ref, T.uji, InStr(1,nz(T.[ref]),nz(T.[uji])) AS depan, InStrRev(nz(T.[ref]),nz(T.[uji])) AS belakang, Len(nz(T.[ref])) AS len_ref, Len(nz(T.[uji])) AS len_uji, Len(nz(T.[ref]))-Len(nz(T.[uji])) AS selisih_len, StrComp(nz(T.[ref]),nz(T.[uji]),0) AS exact FROM T; hasil query di atas ref uji depan belakang len_ref len_uji selisih_len exact abcd abcd 1 1 4 4 0 0 abcdefg abcd 1 1 7 4 3 1 1001 1001 1 1 4 4 0 0 00100 0100 2 2 5 4 1 -1 0 1 1 1 0 1 1 0 0 1 1 1 1 0 0 sebelum tahu StrComp, tadfinya mau pakai kriteria depan = 1, belakang = 1, dan selisih_len=0, alhamdulillah cukup dengan exact/StrComp = 0 cmiiw sinung > ----- Original Message ----- > From: si Nung > To: [email protected] > Sent: Thursday, April 23, 2009 18:16 > Subject: [belajar-access] padanan exact() di access ? > > assalamu'alaikum, > > misal ada dua field yg se-type : > > id_a : > cabA_00011-> harusnya penomoran dengan 5 > cabA_00012 > > dan > > id_b : > cabA_001 -> harusnya penomoran dengan 5 > cabA_00012 > > bila di excel ada function exact() untuk membandingkan antar dua variable, > akan spt rumus =EXACT(A1;B1) --> hasilnya true / false > > apa fungsi yg sama di access ? > > bila ada yg punya, minta dong ... :D > > -- sig mega.ancam.pindahkan.makam.bung.karno http://perempuan.kompas.com/read/xml/2008/07/15/20431926/ -- sig
