Linking dates to check boxes

  • Thread starter Thread starter Peter Castlehouse
  • Start date Start date
P

Peter Castlehouse

Hi guys,

I need an easy way (or hard, so long aas it gets done!) to link check boxes
on a form to the days of the week. Thus when say, Wednesday is checked, I
get a report the day before alerting me that it's checked. Any way to do
this?

tia

Pete
 
I am not understanding your question. Please provide a bit more detailed
info about the form's setup, and when/how the "notification" is supposed to
occur (at the time the box is checked; at a later time because the box is
checked; when the form is opened; etc.).
 
seven check boxes on form. On creation of a record, some checkboxes are
checked, eg Tue, Wed and Friday

In the ensuing weeks, a report run on Mondays will indicate how many 'Tue'
checkboxes are checked and list the record details.
Same applies for next day and so on...

It's for pharmacy dispensations, and they need to know the day before
someone arrives, to prepare the dispenses...because some poeple travel 500km
for the prescriptions.

make more sense?
cheeers

Pete
 
There are many ways to set up your tables and form to handle this.

Probably the easiest is to have a single field for the DateToPickUp in the
table. The data entry form would allow the user to enter the date using a
textbox that is bound to this field.

Then, when you run a report, the report's query would filter based on using
the Date() + 1 expression:
WHERE DateToPickUp = Date() + 1

Thus, the report would print all records whose DateToPickUp is the day after
the report is run.
 
Back
Top