Re: Multiple Dates on a Table

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I would keep the tables normalized. You might want to look at the sample
calendar reports at http://www.access.hookom.net/Samples.htm

--
Duane Hookom
MS Access MVP

"Joan" <joneil@xxxxxxxxxxxxxx> wrote in message
news:1156964437.543393.210870@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I need to create a database to schedule patient appointments. I get
one piece of paper with a years worth of appointments (can be every
week or every month) and I want to be able to plug in all the dates,
then just pull each day one at a time to get my list of patients. Any
suggestions how to set that up? I tried creating differetn fields for
the weeks of the year, but then when I use a query to look for the
date, I have to search in each field. I want to search the whole
database by date. Help!!



.

Relevant Pages

  • Re: Calendar - Scheduling multi-view
    ... There are several calendar reports at ... Duane Hookom ... MS Access MVP ... > | Sid L. ...
    (microsoft.public.access.formscoding)
  • Re: Monthly Calendar Report
    ... Modify the sample to fit your needs. ... >> Check the calendar reports at ... >> Duane Hookom ... >> MS Access MVP ...
    (microsoft.public.access.reports)
  • Re: Calendar Reports
    ... > What is Duane Hookom's calendar reports? ... >> Dim i As Integer ... >> Duane Hookom ... >> MS Access MVP ...
    (microsoft.public.access.reports)
  • Re: How do I take data from a table and create a calendar
    ... I was at the end of my web hosting contract and needed to renew it last ... MS Access MVP ... "Duane Hookom" wrote: ... look at the calendar reports at ...
    (microsoft.public.access.modulesdaovba)