Ronbo, sorry about the inappropriate solicitation post you received in this
thread. the purpose of these unmonitored newsgroups is to offer free
assistance, advice, and suggestions from fellow Access developers, to answer
your question(s) and help you build a better database. hopefully MVP Duane
Hookom's sample database (see his response elsewhere in this thread) will
help you solve your current issue. if not you can always post back to this
thread, or start a new thread, for additional help.

hth


"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