Date prepared and next due date

[aymanmb]

Hi everybody,

I am a newbie as you can tell from my question. So I am assuming I will get a lot of help from you.



I created 2 fields, one for date prepared and anpther for date due next.

the date due next should be 4 weeks from date prepared.

How can I program the date due next to show automatically after entering date prepared.

Thanks

[June7]

This is a calculated value. There is no need for field in table. Calculate the value when and where needed. It can be done in query or in textbox.

Use DateAdd function.

Access Help has guidelines on its use. Experiment until you get the desired result.