Schedulig question

  • Thread starter Thread starter Steve Goodrich
  • Start date Start date
S

Steve Goodrich

We have a database built in Access 97 that is used to book people into our
building,

There are two date fields on the form, Date from & Date To. There are
queries/Reports set up so you can view any days visitors.

This works great if the visitor is expected between two set dates –e.g.
1/3/10 to 31/3/10



On occasions a visitor will need booking in on Monday of each week for two
months or Mon & Tues for six months.



I have a duplicate button on my form which is useful for say two or three
entries, but not very convenient for twenty entries.



My question is this: Is there a way the user could select the days of the
week the visitor is expected, after the two date fields have been completed.



So if the visitor was due every Monday in March and April, the user could
select:

Date from 1/3/10. Date To 30/4/10, then be prompted for the days of the
week, so the user could select Mon only.



Hope this makes sense



Steve
 
Pieter,

Thanks for your reply, I'm very much a novice at Access but I'll try and
work through your suggestion, May have to post again for more help!!

If you could send me the database it would help my understanding,

Many thanks,

Steve
 
Back
Top