mas. Abu kalau banyak mungkin bisa jadi alternatif spt ini:
buat fungsi simpan dimodul:
Public Function udf_Range(theValue As Variant) As String
Dim strRange As String
Select Case theValue
Case 0 To 0.25: strRange = "1"
Case 0.26 To 0.5: strRange = "2"
Case 0.6 To 1: strRange = "3"
End Select
udf_Range = strRange
End Function
trus panggil diquery spt ini:
Range: udf_Range([Field])
jangan lupa kolom nilai (Field) dimunculkan
semoga membantu, mungkin teman2 yg lain ada yg lebih praktis
Salam
Nurhasim
Abu Shafwa <[email protected]> wrote: kalau
logika iif nya sampai dengan 20, apa bisa pakai iif mas?
2009/2/20 [email protected] <[email protected]>
Logikanya sama aja, tinggal dirubah sedikit
misal
dibuat di spt: Range: IIf([field]>=0 And [field]<=0.25,1,IIf([field]>=0.26 And
[field]<=0.5,2,0))
coba spt ini semoga membantu
Salam
Nurhasim
Access Boring <[email protected]> wrote:
Dear senior,
Gimana ya cara buat range di access.
Jadi kurang lebih Kita punya nilai prosentase nih.
Terus untuk percentasi antara:
0 - 25% --> 1
26 - 50% --> 2, DST.
Percentage Category 25.00% 2 87.00% 5 48.00% 3 12.00% 1
0.00% 1 98.00% 5 78.00% 4 56.00% 3
Kalo excel nya sih gini command nya:
=IF(AND(AX244>=0,AX244<=0.2)=TRUE,1,IF(AND(AX244>0.2,AX244<=0.4)=TRUE,2,IF(AND(AX244>0.4,AX244<=0.6)=TRUE,3,IF(AND(AX244>0.6,AX244<=0.8)=TRUE,4,IF(AND(AX244>0.8,AX244<=1),5,6)))))
Tapi kalo di access pake apa ya?
Mohon bantuan temen senior..
THanks,
-Apeep-
--
--------------------------------------/*
Abu Shafwa
www.kromosom.net
[email protected]
[email protected]
*\--------------------------------------
