Cheers Brian - works a treat, but...........
When I open the form that has the text box containing the formular a little window appears showing me the months total and todays date with an OK button. How do I stop this little window from appearing?
I need to put in the control source field as...