Hello,
I am looking to construct a query that will allow me to update a table based off calculated delivery date. I do not want to include weekends since no delivery will occur. Is there a way to do this in Access? I noticed there was not a "Networkdays" function like there is in Excel.
Below is an example. I want to be able to calculate the Delivery date based off the Ship date and expected transit days.
Need to add the Ship date and Expected Transit Days together, get the date then convert it to not include weekend days.
below are the fields in the table. Table entitled [tbl_current_tracking_nbrs]
SHIP_DATE Expected_Transit_Days Delivery_Date
Thank you!
I am looking to construct a query that will allow me to update a table based off calculated delivery date. I do not want to include weekends since no delivery will occur. Is there a way to do this in Access? I noticed there was not a "Networkdays" function like there is in Excel.
Below is an example. I want to be able to calculate the Delivery date based off the Ship date and expected transit days.
Need to add the Ship date and Expected Transit Days together, get the date then convert it to not include weekend days.
below are the fields in the table. Table entitled [tbl_current_tracking_nbrs]
SHIP_DATE Expected_Transit_Days Delivery_Date
Thank you!