Hi Rick. Could you advise me which Lesson I need to buy next to solve my following question: I have a column of dates (eg date when an inital email was sent to potential clients). I want to send a reminder email 14 days from the date I sent the first one. In Excel I was able to do this using "=" the cell in the original column, "+14". I can't see how to do this in Access but I'm sure there must be a way. Could you direct me to the best lesson that might illustrate this for me please. Many thanks!
Reply from Richard Rost:
You would do it almost the same way as in Excel. Whole days are equal to 1. So =Date+1 is tomorrow. So in a query make a calculated field and say:
NewDate: OldDate+14
That will now give you a new field (column) of values representing 14 days after OldDate.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Microsoft Access 201.
