Date Field + new field

[gstephens]

Hi, this is my first post...

I have a date field in a table. It represents the start of a project e.g 1st April 2013.

In my work we have a number of days to complete a task. Lets say it is 10 days. This is stored in another field.

I want a third field to be a calculation e.g. [Date]+ 10. The answer would be 11th April 2013. This tells me I have until 11th April to get this task completed.

How do I get MS Access to do this? I am trying to do it in a form. Any assistance gratefully received.

Thanks

 

[missinglinq]

Since this is a Calculated Value, you do not want to store it in a Table, only use it for display. If you need it later you simply re-calculate it.

Create an Unbound Textbox, and with it selected go to Properties - Data and in the Control Source Property enter

=[StartDate]+[Days2Complete]

replacing StartDate and Days2Complete with your actual names.

Linq ;0)>

 

[boblarson]

Since this is a Calculated Value, you do not want to store it in a Table, only use it for display. If you need it later you simply re-calculate it.

Create an Unbound Textbox, and with it selected go to Properties - Data and in the Control Source Property enter

=[StartDate]+[Days2Complete]

replacing StartDate and Days2Complete with your actual names.

Linq ;0)>

What he wrote ^^^^^^^^^^^^^^^^^^^