Mark,

Here's a suggestion ---

Create these tables ---
TblWorkstation
WorkstationID
WorkstationName
etc

TblTask
TaskID
TaskDescription

TblWorkstationTask
WorkstationTaskID
WorkstationID
TaskID
WeekDayToBeDone

Note: WeekDayToBeDone Is an integer. Sunday =1, Monday = 2, Tuesday = 3,
etc.

For data entry build a form/subform. Base the main form on TblWorkstation
and the subform on TblWorkstationTask. You will have multiple records in the
subform for the tasks that are performed on any workstation more than once
per week. Set the Linkmaster/LinkChild properties to WorkstationID.

For displaying the tasks to be done today, also use a form/subform. In the
mainform, you need two unbound textboxes. Name the first textbox
"TodaysDate" and put the following expression in its ControlSource:
=Date()
Name the second textbox "TodaysWeekDay" and put the following expression in
its ControlSource:
=WeekDay(Date())

For the subform, create a query based on all three tables and include the
appropriate fields to identify the workstation and the task. Be sure to
include WeekDayToBeDone from TblWorkstationTask.

For the LinkMaster property, type in [TodaysWeekDay] and for the LinkChild
property, type in [WeekDayToBeDone].

When this form opens, it will display a list of tasks for each workstation
for today.

I have a week calendar form and report module. It could be used to display
the schedule of tasks for your workstations in a calendar layout. As the
module name implies the form and report look like a page torn off a
calendar. I can implement my calendar form and report module in your
database for a very reasonable fee. If you are interested, contact me at my
email address below and I will send you a screenshot.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

Over 1000 Access users have come to me for help. My fees are very
reasonable.




"MSEMD" wrote in message
...
I am attempting to build a database that will generate a task list for
multiple workstations. I have tasks that need to be completed either
daily,
on a certain day of the week, or mutiple days of the week. I am unclear
how
to associate the task(s) with the appropriate frequency.

Also, I would like to have the query use the system clock to determine the
appropriate day of the week.

Thoughts?

Mark