Access Date field

[Johanb26]

Hi guys,



In our database we have a sample tested date field. What I want to add is another date field "date for next test" - So when the test date is entered the date + 12 months should be auto entered into the "date for next test" field.

Can anyone help me with the code for this ?

Thank You

[RuralGuy]

That date can always be calculated in a query and should not be a field in a table.

[Johanb26]

That date can always be calculated in a query and should not be a field in a table.

Thanks a million!!I'm an idiot complete forgot I can do that

[RuralGuy]

Excellent! Glad we could help.