Automatically generate data

[Guest]

Guys,

One of my users has a database which has a Field called Visit date which is
of course set as Date/Time. She wants to have another field called Next visit
which will automatically put a date in. This date should be the visit date
plus 7 days.

So the idea is that once she enters the visit date, a date 7 days later is
automatically placed in the next visit field.

Is this possible and how would we do it?

 

[Joseph Meehan]

Guys,

One of my users has a database which has a Field called Visit date
which is of course set as Date/Time. She wants to have another field
called Next visit which will automatically put a date in. This date
should be the visit date plus 7 days.

So the idea is that once she enters the visit date, a date 7 days
later is automatically placed in the next visit field.

Is this possible and how would we do it?

Possible yes. Good idea NO.

Rather than make a field and save the date, you should simply display
the date or a reminder based on the date when and where wanted. There is no
need or reason to save it.

You might display it on a form or check to see if any are due in the
next day or so and provide a list any time the database is opened for
example.

 

[Guest]

Joseph,

Thanks for your reply.

Rather than make a field and save the date, you should simply display
the date or a reminder based on the date when and where wanted. There is no
need or reason to save it.
You might display it on a form or check to see if any are due in the
next day or so and provide a list any time the database is opened for
example.

So how would we go about that?

 

[Joseph Meehan]

Joseph,

Thanks for your reply.


So how would we go about that?

Let's start with how and where and when does this information get
displayed or used?