I am working on a Microsoft Access database for a drug rehab clinic and this is what I need to do.
I need to beable to take DaysSpent and multiply by cost per day to get CostOfStay. What is throwing me off is there are two pricing catagories(ProvService) and I cant figure out how to multiply by each pricing catagory.
Note:when ProvService=02, cost per day is $150, when ProvService=05, cost per day=200
This is my code so far...
CostOfStay: IIf([ProvService]=2,([DaysSpent]*150),IIf([ProvService]=5,([DaysSpent]*200)))
it is just showing #ERROR in the output.
Any ideas for a modifaction in my IIf statement, or am I going about the problem all wrong and using an IIf statement isnt something I should use in this situation.
Thanks in advance