UPDATING

  • Thread starter Thread starter RAY
  • Start date Start date
R

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.
 
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.
 
Back
Top