OK gotcha.



Lets put this question on hold for a bit. I think its hard to solve this one on a forum. I'll wait til our office's Access expert is back to explain what the problem was and then I'll say so on the forum if he's able to answer it. In the meantime I'm just doing the calculations in Excel.