If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Linking Date Fields
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 |
#3
|
|||
|
|||
Linking Date Fields
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 |
Thread Tools | |
Display Modes | |
|
|