Hi All,

I am trying to build a user defined function in access database but currently having problems of Object Required Error, the formular i am trying to use works perfectly in Expression builder but due to expression builder limitation, i am forced to use a defined function to achieve a work around. Below is the formular used in expression builder:

PAYG_Multiplier: Switch([PAYGMultiplier]![PAYGLASTMONTH] >=0 And 0.8,-1,[PAYGMultiplier]![PAYGLASTMONTH]>0.8 And [PAYGMultiplier]![PAYGLASTMONTH]<=0.81,-0.4)


Please can anyone help piont me in the right direction.

Many thanks.


Afolabi