I am trying to create an access database that will show upcoming appointments
with clients. These appointments are always recurring every month, 3 months,
or 6 months. I would like to enter the appointment and client information
into a table one time and then see the appointments when I open a weekly or
monthly report. Also, I want to mark the appointment complete in my table
after it is held so that a meeting that is scheduled but not held will
automatically show on the next week's calendar.

I have created several other somewhat complex databases in Access for my
company, but I am having trouble with this one. Any help that you can offer
on any of these points would be GREATLY appreciated!!!!!
Thanks