Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Table View: using a date formula to get a later date

Status
Not open for further replies.

AccipiterQ

Programmer
May 25, 2005
27
US
I have this database, and one field is a start date, and another field is a date to mail out a thank you letter. I want this field to automatically display a date 5 days ahead of what the start date field is. I've seen how to do this in a form, but I need to do this from a table, and since I'm relatively new to access, I can't figure it out, and I can't find anything pertinent in MS's help...
 
Since the field that you want is a computed field, you should probably create it in a query rather than storing it in the table. If your table has something like
[tt]
myTable
ID Primary Key
StartDate Date Field
[/tt]
Then the SQL
Code:
Select ID, StartDate, DateAdd("d", 5, [StartDate]) As MailOutDate
From myTable
will give you the computed field that you want.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top