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(Prov Service) 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

...