date range with exception

[rob c]

I need to set up a form that allows someone to enter a range of dates, then
remove specific dates within that range. How could I do that?

 

[OssieMac]

Hi Rob,

Can you give an example of the range. I'd like to know approximately how
many days between start and finish dates.

I am assuming that you want to enter the start date and end date and have
all the intermediate dates created in a table automatically. Is this
assumption correct?

Also, the dates to remove (or actually not create). Are they random or is
there a specific criteria like Sat and Sun or some other identifiable
criteria?

 

[rob c]

The database is used to track which project a person is scheduled to be
working on. Probably a week or two range with the ability to take a day out
of that range if the person will be working on a different project for that
day.

 

[John W. Vinson]

I need to set up a form that allows someone to enter a range of dates, then
remove specific dates within that range. How could I do that?

How - in your database, in database jargon, not in terms of why you want to
exclude the dates - are the dates to be excluded specified? Are they in a
table somewhere, on a form, drawn from a calendar,... ??

You might consider having a Calendar table filled with dates from now through
the next two decades or so (you can easily create this using Fill... Series in
Excel and copy and paste), in conjunction with an ExcludedDates table; but
since you have chosen not to post the logic of how excluded dates are
determined, it's hard to be sure.

 

[Mike Painter]

I need to set up a form that allows someone to enter a range ofYou can add the dates manually or with code.
They would go into a table with some relationship to the job(?),
employee(?), or ???
Add a check box to this table and set the default to what ever is
appropriate.
If the box is labeled exclude the default would be false and checked boxes
would be excluded.
Base a (sub)form on those dates and the check box.
Reports, etc. would be based on what you need and the status of the
checkbox.

Adding a "Select All" and "deselect all" buttons are a nice touch.
I've done this with reports where you want to see Test A,B, C for doctors
X.Y, Z and it is easy to implement and clear to the user, as long as the
check box name is clear.

 

[OssieMac]

Hi Rob,

Wasn't able to get back to you sooner. However, I don't think I can add much
to what John and Mike have said. It's a complex issue to properly design a
database but basically as per the other posts, I think you should have a
table from which you can select dates and have a relationship set between the
date table and the projects.

Your answer to my question suggests that you want a database to track the
time spent on jobs and/or to program the work for the workers. Perhaps if you
post a question to try to find a sample database to perform these functions
might be more appropriate. I feel sure that someone will know where to find
one.