Due Date Question

[Guest]

I have a database and two of the fields are called "Sent To Company" and the
other "Destroy Date" - They refer to documentaion which must be destroyed
after 6 months. A date is entered in the "Sent To Company" field and I want
the Destroy Date field to be automatically populated with a date 6 months
after the "Sent To Company" date.

I have looked at the threads and tried various suggestions but cannot seem
to get the criteria line to work.

I am a bit new to this so if you could keep replies as basic as possible
please.

Thanks in advance

 

[Guest]

Hi SR,

You should not be attempting to store a value that can be calculated on the
fly. Doing so violates 2nd and 3rd normal form of database design. Instead,
just calculate the destroy date whenever it is needed. Here are some links
that you might find helpful:

http://office.microsoft.com/en-us/assistance/HA010546621033.aspx
and
http://office.microsoft.com/en-us/assistance/HP010984851033.aspx

In a query, entered on the Field row in the Query by Example grid:
Destroy Date: DateAdd("m", 6, [Sent To Company])

As a control source for a calculated textbox:
=DateAdd("m", 6, [Sent To Company])


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Dear Tom

Thank you for your prompt response and your advice - Everything is now
working as I had hoped for.

Much appreciated

SR7133

Hi SR,

You should not be attempting to store a value that can be calculated on the
fly. Doing so violates 2nd and 3rd normal form of database design. Instead,
just calculate the destroy date whenever it is needed. Here are some links
that you might find helpful:

http://office.microsoft.com/en-us/assistance/HA010546621033.aspx
and
http://office.microsoft.com/en-us/assistance/HP010984851033.aspx

In a query, entered on the Field row in the Query by Example grid:
Destroy Date: DateAdd("m", 6, [Sent To Company])

As a control source for a calculated textbox:
=DateAdd("m", 6, [Sent To Company])


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

I have a database and two of the fields are called "Sent To Company" and the
other "Destroy Date" - They refer to documentaion which must be destroyed
after 6 months. A date is entered in the "Sent To Company" field and I want
the Destroy Date field to be automatically populated with a date 6 months
after the "Sent To Company" date.

I have looked at the threads and tried various suggestions but cannot seem
to get the criteria line to work.

I am a bit new to this so if you could keep replies as basic as possible
please.

Thanks in advance

 

[Guest]

Hi SR,

Glad I could help. Good luck on your project!


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________