How do I add business days in access?

[Guest]

Here's what I am trying to do.

Use the number of days an item is in transit, translate that number over to
weekdays, and add it to the date that the item was shipped. Resulting in the
day I can expect to get said item(s).
[shipdate]+[shippingdays(as weekdays)]=[expectedreceipt]

So if item leaves on Friday and takes 3 days to get to me, I want it
calculated to display Wednesday.

I have been trying to do this in a macro, but I am not set with it having to
be a macro.

Any help is greatly appreciated.

 

[Rick B]

Did you try searching?

The following link contains several past posts with responses...
http://groups-beta.google.com/groups?q=microsoft.public.access+"business+days"&qt_s=Search

Hope that helps,
Rick B

 

[Guest]

Yes I did search, the only relavent thing it brought up was explanations for
how to count [date1]-[date2] between dates to get the resulting business days
between them.

Only 1 link, in your search even remotely begins to explain what I am
asking, just happens that they have an example. So yeah, instead of reading
through 8 pages of code, I 'thought' why not ask to see if there's an easy
way (like DatePart("w",[Forms]![T]![SD])+[Forms]![T]![DD] --abreviated).

Ahh well, guess that's what I get for asking, I'll go back to my corner and
play with it til I get it (like I normally do).

Did you try searching?

The following link contains several past posts with responses...
http://groups-beta.google.com/groups?q=microsoft.public.access+"business+days"&qt_s=Search

Hope that helps,
Rick B

Here's what I am trying to do.

Use the number of days an item is in transit, translate that number over to
weekdays, and add it to the date that the item was shipped. Resulting in the
day I can expect to get said item(s).
[shipdate]+[shippingdays(as weekdays)]=[expectedreceipt]

So if item leaves on Friday and takes 3 days to get to me, I want it
calculated to display Wednesday.

I have been trying to do this in a macro, but I am not set with it having to
be a macro.

Any help is greatly appreciated.

 

[Douglas J. Steele]

Check the Date/Time section of "The Access Web", specifically
http://www.mvps.org/access/datetime/date0012.htm

 

[Dirk Goldgar]

Yes I did search, the only relavent thing it brought up was
explanations for how to count [date1]-[date2] between dates to get
the resulting business days between them.

Only 1 link, in your search even remotely begins to explain what I am
asking, just happens that they have an example. So yeah, instead of
reading through 8 pages of code, I 'thought' why not ask to see if
there's an easy way (like
DatePart("w",[Forms]![T]![SD])+[Forms]![T]![DD] --abreviated).

Ahh well, guess that's what I get for asking, I'll go back to my
corner and play with it til I get it (like I normally do).

I know it's frustrating, but I don't think you pursued those links very
far. The third one included a reply containing a link to the same page
Doug Steele just pointed you to, which does indeed contain exactly the
code you're looking for.

 

[Guest]

Sorry I seem to get upset when someone does a google search and posts it.

Thank you Dirk and Douglas, your comments/links were insightful. However I
chose to use another method, it might not be as 'clean' but it works. Just
did the calc in excel and linked the SS with the DB and put a macro in to
copy/paste from point a to point b when the form is opened. (felt the need to
thank you for your help)

Before someone says macro's?!? Data in=Data out, therefore the life of the
data is at max 4 days then it's deleted. So it's not like it'll cause
problems.

Off to go read up on how to hyperlink+data+next

Check the Date/Time section of "The Access Web", specifically
http://www.mvps.org/access/datetime/date0012.htm

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Here's what I am trying to do.

Use the number of days an item is in transit, translate that number over
to
weekdays, and add it to the date that the item was shipped. Resulting in
the
day I can expect to get said item(s).
[shipdate]+[shippingdays(as weekdays)]=[expectedreceipt]

So if item leaves on Friday and takes 3 days to get to me, I want it
calculated to display Wednesday.

I have been trying to do this in a macro, but I am not set with it having
to
be a macro.

Any help is greatly appreciated.