First of all let me thank all that responded to my "I'm at a lost"
post, "Database Sluggish Post" etc. Posts. I tried your ideas but I'm
afraid that I corrupted the database when I forced quit after
realizing the calc change was going to take 2 days to make (maybe a
slight exaggeration). But now I am reconciled to the fact that the
only salvation I have is to rebuild.
So to that end I'd like to ask how others might go about setting up a
scheduling database that requires work days and a special
consideration for holidays? Since that is the biggest portion of the
database. I currently use a calendar table that doesn't have weekends
or the special holidays that are in academia listed. By using "Lookup
next" calcs and straight Look up fields the correct date is entered
and then adding the appropriate number of work days to the calc I
can go to the next date. This goes on for 11 date fields ( maybe a
clue to the lengthly recalculation time huh?).
Is there a better way? I'm going to start Monday morning after a
weekend of washing my sorrows away.
Again I can't thank you folks enough for your advise.
Peter
