AJ,
You managed to supply an answer but it seems you didn't see my post, so let
me ask again...
We're going to need a wee bit more information... Set it up where? On a
report, on a form... or maybe on a calendar control? Which four days?
Mon-Thu or maybe Tue-Fri? Do you need to do calculations? Will there be
overtime? Are you worried about the hours at all? Well, you get the
idea...
--
Gina Whipp
2010 Microsoft MVP (Access)
"I feel I have been denied critical, need to know, information!" - Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Details do matter don't they? Sorry.
This is an access database. We use it to load production data. Our
production runs 4 day weeks. I'm trying to calculate teh datediff between
events, but need to account for the weekends/holidays with the weekends
being
the Friday-Monday. I would be doing the calulation in either a report or
query.
Thanks, hope that does a better job explaining than my first try.