Complex formula

[007700]

Hi there,

I have created a complex formula in Excel and need to apply it in a query/report in Access.
Now have I never applied such a formula into access and am therefore unsure on where to apply it.
Could anyone help me on where / how to apply the formula ?
It's about calculating days of the month and bassed uppon that calculating a price.

=(IF(((edrm-$B9-thismonth) +1)<=lastmonth;IF(((edrm-$B9-thismonth) +1)<=0;0;(((edrm-$B9-thismonth)+1)/lastmonth)+1);1))*cost

 

[BNPMike]

You can use an IIF statement in the QBE Grid. You'll need to substitute a table value for $B9. Is $B9 the same for all rows or does it vary row by row?

 

[007700]

The $B9 is a date value that the user has to select from a drop down list.