My data is as follows:
ShipDate: 2005-04-01 00:00:00.000
OrigZipCode 054
DestZipCode 054
ExpectedDeliverDate 2005-04-04 23:59:59.000
ActualDeliverDate 2005-04-05 12:15:00.000
I need some major help. I need to figure out what type of product is being shipped based on ship date and expected delivery date. I need to write a query that shows me how many business days each package took and if the package was delivered on a Saturday, I need to note that this was a Saturday delivery. I've got several thousand records. Is there a way to do this is a query statement rather than vba? I know nothing about vba.
Thank you
ShipDate: 2005-04-01 00:00:00.000
OrigZipCode 054
DestZipCode 054
ExpectedDeliverDate 2005-04-04 23:59:59.000
ActualDeliverDate 2005-04-05 12:15:00.000
I need some major help. I need to figure out what type of product is being shipped based on ship date and expected delivery date. I need to write a query that shows me how many business days each package took and if the package was delivered on a Saturday, I need to note that this was a Saturday delivery. I've got several thousand records. Is there a way to do this is a query statement rather than vba? I know nothing about vba.
Thank you