Subtracting on field value from another

Hi Ross,

Thank you for your question.

The two tables should be linked first.

Create a query and insert the appropriate fields needed for the new calculation. In the next available blank field type the name of the new calculated field followed by a colon to show that is the end of the field name:

e.g. LengthOfService:[HireDate]-[FinishDate]

After you have type the formula in make sure you click the Show checkbox.

I hope this answers your question.

Regards

Simon