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-
