adding intervals to dates

[gfell]

I am using Access 2002. I am entering contact data, putting in first meeting
dates. I want to generate an automatic action plan for following up. For
example, the first follow up call should be 7 days after the first meeting
date, the second followup should be 5 days after the first follow-up. It
would be great to get an automatic report, say each Monday, since that would
be my 'to do' list for the week.

I would really appreciate any help as I have tried everything with no
success. thanks

 

[Jeff Boyce]

Check the DateAdd() function. Use it in a query.

Good luck

Jeff Boyce
<Access MVP>

 

[gfell]

I tried that and for"date" I clicked on the table/meeting date but i am not
sure what the difference is between 'interval' and "number". i want to add 7
days to the "meeting date" field in the table and get the new date
automatically. thanks

 

[Jeff Boyce]

Checking Access HELP on the proper syntax (and examples) should give you
some idea.

In a query (you ARE working in queries, right, and not directly in the
table?), you can create a new field for display with something like (your
syntax may vary):

YourNewField: DateAdd('d',7,[YourDateField])

Good luck

Jeff Boyce
<Access MVP>

 

[Jeff Boyce]

If you are proposing to store a date 7 days from the date you already have
recorded, don't. If you can calculate it, do so in a query, not in the
table.

Good luck

Jeff Boyce
<Access MVP>

 

[gfell]

Yes, i am working in Query and have clicked on help but to no avail. in the
query design view, i put your formula in the criteria box since it won't let
me put it in the field box but i still get nothing. is it possible to take
me through an example? what i need to to generate a report that tells me to
follow up after 7 days of a "Last meeting date:"

many thanks again.

Checking Access HELP on the proper syntax (and examples) should give you
some idea.

In a query (you ARE working in queries, right, and not directly in the
table?), you can create a new field for display with something like (your
syntax may vary):

YourNewField: DateAdd('d',7,[YourDateField])

Good luck

Jeff Boyce
<Access MVP>

I tried that and for"date" I clicked on the table/meeting date but i am not
sure what the difference is between 'interval' and "number". i want to
add 7
days to the "meeting date" field in the table and get the new date
automatically. thanks

 

[Jeff Boyce]

I don't understand. Access allows me to put the expression in the Field
box.

You don't want the date 7 days from now to be a criterion -- you want to see
the date 7 days in the future.

"to no avail" doesn't tell us very much about what happens when you click on
Help.

Can you switch to SQL view, copy the SQL statement, and paste that into a
post to the 'group?

Good luck

Jeff Boyce
<Access MVP>

Yes, i am working in Query and have clicked on help but to no avail. in
the
query design view, i put your formula in the criteria box since it won't
let
me put it in the field box but i still get nothing. is it possible to
take
me through an example? what i need to to generate a report that tells me
to
follow up after 7 days of a "Last meeting date:"

many thanks again.

Checking Access HELP on the proper syntax (and examples) should give you
some idea.

In a query (you ARE working in queries, right, and not directly in the
table?), you can create a new field for display with something like (your
syntax may vary):

YourNewField: DateAdd('d',7,[YourDateField])

Good luck

Jeff Boyce
<Access MVP>

I tried that and for"date" I clicked on the table/meeting date but i am
not
sure what the difference is between 'interval' and "number". i want to
add 7
days to the "meeting date" field in the table and get the new date
automatically. thanks

:

Check the DateAdd() function. Use it in a query.

Good luck

Jeff Boyce
<Access MVP>

I am using Access 2002. I am entering contact data, putting in first
meeting
dates. I want to generate an automatic action plan for following
up.
For
example, the first follow up call should be 7 days after the first
meeting
date, the second followup should be 5 days after the first
follow-up.
It
would be great to get an automatic report, say each Monday, since
that
would
be my 'to do' list for the week.

I would really appreciate any help as I have tried everything with
no
success. thanks

 

[gfell]

hi,
I copied and pasted your expression this time and it worked!!!! thanks so
much for the help. one last silly quesion--how can I change the column name
to something other than "expr 1"?

I don't understand. Access allows me to put the expression in the Field
box.

You don't want the date 7 days from now to be a criterion -- you want to see
the date 7 days in the future.

"to no avail" doesn't tell us very much about what happens when you click on
Help.

Can you switch to SQL view, copy the SQL statement, and paste that into a
post to the 'group?

Good luck

Jeff Boyce
<Access MVP>

Yes, i am working in Query and have clicked on help but to no avail. in
the
query design view, i put your formula in the criteria box since it won't
let
me put it in the field box but i still get nothing. is it possible to
take
me through an example? what i need to to generate a report that tells me
to
follow up after 7 days of a "Last meeting date:"

many thanks again.

Checking Access HELP on the proper syntax (and examples) should give you
some idea.

In a query (you ARE working in queries, right, and not directly in the
table?), you can create a new field for display with something like (your
syntax may vary):

YourNewField: DateAdd('d',7,[YourDateField])

Good luck

Jeff Boyce
<Access MVP>

I tried that and for"date" I clicked on the table/meeting date but i am
not
sure what the difference is between 'interval' and "number". i want to
add 7
days to the "meeting date" field in the table and get the new date
automatically. thanks

:

Check the DateAdd() function. Use it in a query.

Good luck

Jeff Boyce
<Access MVP>

I am using Access 2002. I am entering contact data, putting in first
meeting
dates. I want to generate an automatic action plan for following
up.
For
example, the first follow up call should be 7 days after the first
meeting
date, the second followup should be 5 days after the first
follow-up.
It
would be great to get an automatic report, say each Monday, since
that
would
be my 'to do' list for the week.

I would really appreciate any help as I have tried everything with
no
success. thanks

 

[Jeff Boyce]

Highlight the "Expr1". Change it to whatever you want. Save the changes.

Jeff Boyce
<Access MVP>

hi,
I copied and pasted your expression this time and it worked!!!! thanks so
much for the help. one last silly quesion--how can I change the column
name
to something other than "expr 1"?

I don't understand. Access allows me to put the expression in the Field
box.

You don't want the date 7 days from now to be a criterion -- you want to
see
the date 7 days in the future.

"to no avail" doesn't tell us very much about what happens when you click
on
Help.

Can you switch to SQL view, copy the SQL statement, and paste that into a
post to the 'group?

Good luck

Jeff Boyce
<Access MVP>

Yes, i am working in Query and have clicked on help but to no avail.
in
the
query design view, i put your formula in the criteria box since it
won't
let
me put it in the field box but i still get nothing. is it possible to
take
me through an example? what i need to to generate a report that tells
me
to
follow up after 7 days of a "Last meeting date:"

many thanks again.

:

Checking Access HELP on the proper syntax (and examples) should give
you
some idea.

In a query (you ARE working in queries, right, and not directly in the
table?), you can create a new field for display with something like
(your
syntax may vary):

YourNewField: DateAdd('d',7,[YourDateField])

Good luck

Jeff Boyce
<Access MVP>

I tried that and for"date" I clicked on the table/meeting date but i
am
not
sure what the difference is between 'interval' and "number". i want
to
add 7
days to the "meeting date" field in the table and get the new date
automatically. thanks

:

Check the DateAdd() function. Use it in a query.

Good luck

Jeff Boyce
<Access MVP>

I am using Access 2002. I am entering contact data, putting in
first
meeting
dates. I want to generate an automatic action plan for following
up.
For
example, the first follow up call should be 7 days after the
first
meeting
date, the second followup should be 5 days after the first
follow-up.
It
would be great to get an automatic report, say each Monday, since
that
would
be my 'to do' list for the week.

I would really appreciate any help as I have tried everything
with
no
success. thanks