Populate a field with a value derived from other fields

[Hfnet]

I have a table with a datein and dateout fields, and one for normal or urgent. I have a module that calculates the weekdays between the two dates. What i want to do is have a field within each record that is the count of weekdays combined with the normal or urgent. i.e. if the job is normal (value 1) and days is less than 3, the count field is 1 - if normal and days is between 3 and 5 days, count is 2, if normal and over 5, count is 3. If the dateout field is null, then the date is to be set to today.

This field is then used in a continuous form to give a backcolor of a conditional format text box depending on days in and urgency.

Any ideas of how I can do this automatically and store the value of 1,2, or 3 in the BoxCol field?

Thanks

 

[lespaul]

Why do you want to store this information? Just add it to the query that's used as the report source.

 

[Hfnet]

I'm new to this kind of thing, and I really don't know where I would start. I am taking the form data direct from the table and displaying it as continuous forms.