conditonal expression

[KIMBOZZZ]

help with conditonal expression
how do i?......


field a
b
c
d
e
f
g
h
i

i need to make a conditional calculation.... on fields h and i

...h= if g-c= or <0 then h=0
if g-c>0 and <e then h=((g-c)/100)*d
if g-c= or >e then h=(e/100)*d

...i= if g-c<e then i=0
if g-c>e then (((g-c)-e)/100)*f

can anyone form thes two onto the proper syntax for each field? ....pretty please!!!!

 

[IfButOnly]

I think it is

h=iif(g-c=>e,(e/100)*d,iif(g-c<1,0,((g-c)/100)*d))

i= iif(g-c<e,0,((g-c)-e/100)*f)

 

[Rich]

Wasn't it answered here ?
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=37712

 

[KIMBOZZZ]

thanks very much.... i've now got it all working
still dont quite get the hang of the syntax but hey.... if it works ....so what?!!
thanks again..

best....kimbo