Linking Date Fields

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

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Nicci" wrote in message
...
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

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

--
Good luck

Jeff Boyce
Access MVP