using a module in table calculations

[Homegrownandy]

I have a custom module called workdays. and I have the following code assigned to a text box:

=Work_Days([Date_Added],[Old date])

This does what I need on the form. But I need to store the value generated. I don't know how to do this. EITHER from the from I would keep the value. OR use it in a calculation at the table level. I cant do either.

Anyone have any advice which direction to investigate? or any solutions?

Thanks Andy.

[pbaldy]

You can use his method for storing:

http://allenbrowne.com/casu-14.html

I'm pretty sure you can only use built-in functions in a calculated field (at the table level).

[Homegrownandy]

I didn't use it for storing, I couldn't work it out haha. But thanks to that link and some investigation I'm able to use it in query's and reports. I wanted to keep it as data but I now understand and realise there is no need to.

Thanks for your help.

[pbaldy]

No problemo!