MS Access 2007 - Add time element to query/table
Posted on 2014-10-30
I have an Access 2007 database.
I ship using UPS WorldShip.
When UPS WorldShip processes a shipment label it exports the tracking number and estimated delivery date (formatted as: 20141104 - Nov. 4, 2014 - for example) into a table (UPS_Tracking_Info) in Access.
I would like to send customers a (mail merge) email after two weeks asking them to fill out a brief 2 or 3 question survey of what they purchased.
The query that I would need to join the UPS_Tracking_Info, Orders, and Customers table I can take care of. What I would like to know is if there is a way to add 14 days to the delivery_estimate field (delivery_estimate + 14)?
Is there a way of doing this?
Any help would be greatly appreciated.