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- > > > > > [image: FREE Animations for your email - by IncrediMail! Click > Here!]<http://www.incredimail.com/index.asp?id=109094&rui=111413272> > > > > -- --------------------------------------/* Abu Shafwa www.kromosom.net [email protected] [email protected] *\--------------------------------------
