UPDATING

[RAY]

Is there a simple way to update one field by inputting
information in another. i.e. input date "a" in field 1
will update date "b" by +30 days in field 2.

Thanks in advance.

 

[Douglas J. Steele]

As long as you're not trying to store the calculated value (that's actually
a violation of relational database theory).

You can add a computed field to a query (NewDate: DateAdd("d", 30,
[OriginalDate]) and then use the query wherever you would otherwise have
used the table.