Date Problems

[Molly]

I have a field called treatment date and a field called WHP Days. I would like to add the number in WHP Days to the date and show result in another field called WHP Safe Date. Can someone help?

Molly

[kd2017]

Youll want to create a query, you'll simply create a calculated field [treatment date]+[whp days]. You'll be tempting to create this calculated field in the table, don't do it. Use a query.

[ssanfu]

And you should NEVER have spaces in object names.

Example: A better name for "treatment date" would be "TreatmentDate" or "treatment_date".

[JoeM]

Youll want to create a query, you'll simply create a calculated field [treatment date]+[whp days]. You'll be tempting to create this calculated field in the table, don't do it. Use a query.

This is excellent advice.

Unless these underlying values are changing, and you are trying to capture and store the value as of a specific point in time for historical purposes, the general rule of thumb is "never store any calculation which can be done on-the-fly pretty easily". Doing so ruins the dynamic nature of the database, and can undermine data integrity.

[Molly]

Thankyou I have created a query, and all works
Molly