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
----- 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
