There is a sample mdb for creating recurring events at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane.

To get the "appropriate day of the week", you can use Date() in your
queries.

--
Duane Hookom
MS Access MVP


"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