Automatically fill in data based on data in another field in the table

[ChadK]

New to all of this, I hope someone can help. I have a table that
contains a date field. I would like to have another field in that
table that is automatically filled in with a date of 45 days after the
date that is entered in the first date field. Is this possible?

 

[Jeff Boyce]

Possible, but rarely necessary.

If you know that the second date will ALWAYS be 45 days after the first
date, you don't need to store it.

Instead, consider using a query and the DateAdd() function to calculate it.

Regards

Jeff Boyce
Microsoft Office/Access MVP