Linking Date Fields

[Nicci]

I have a date field. I want to link it to another date
field so when a date is entered in the first date field,
a date one month later is shown in the second date field.

Help much appreciated.

Thanks

 

[Douglas J. Steele]

Sorry, but you don't want that. It violates relational database principles.
Derived values should rarely (if ever) be stored in tables.

Instead, add the date to your table, then create a query that has an
additional computed field that uses DateAdd("m", 1, [DateField]) to produce
the second field. Use the query wherever you would otherwise have used the
table.

 

[Jeff Boyce]

Nicci

As Doug points out, you don't need or want to create a second table field
that is a derivative of a first. This might be the only way to accomplish
what you want in Excel, but Access can do so much more...

You are posting in the tablesdbdesign newsgroup -- the query Doug wrote
about and the place you want to be actually working with the data is in a
form, not directly in the table. Try posting the same question to the forms
newsgroup...