Subform/Calculations

[Danny]

Greetings,
1. I have a main form called Household and a subform called Applicants. In the main form I have NumOfApp field, where I would like to automatically be filled depending on how many people applied in the Applicants form.
2. Also, I have DateReceived and DateDue fields in the Applicants form.
The DateDue is calculated by adding 10 workdays(DateReceived + 9) to the
DateReceived and put the result into DateDue field automatically.
So the user don’t have to figure out manually when the DateDue is.
How can this be accomplished?
Thanks,
DD

 

[KevinM]

You do not need to store either of the fields in a table.

Instead...

1) Use the DCount function in an unound text box or a totals query.

2) Use the DateAdd function in an unound text box or query expression

Lokk these up in the Help files.