J
Jackie L Preston
I have a patient visit table structured as Name, Date, VisitCode, Date1,
VisitCode1, ...Date6, VisitCode6 corresponding to the 7 days of the week.
Name is a text field, Date* - date field, and VisitCode* text field.
What I want to do is get a report with the count of the number of patients
seen on a particular date. For one pt it might be Date1 and another it
might be Date6 depending on whether it was an initial visit or a subsequent
one. I don't need to know the particular patients or visits, just the total
number seen on Date2 (Wednesday, 2/14/07) for example. I suspect there is a
fairly simple answer but I am somewhat "query challenged". An average of
the number seen on all dates would be great.
Thanks,
Jackie L Preston MD
VisitCode1, ...Date6, VisitCode6 corresponding to the 7 days of the week.
Name is a text field, Date* - date field, and VisitCode* text field.
What I want to do is get a report with the count of the number of patients
seen on a particular date. For one pt it might be Date1 and another it
might be Date6 depending on whether it was an initial visit or a subsequent
one. I don't need to know the particular patients or visits, just the total
number seen on Date2 (Wednesday, 2/14/07) for example. I suspect there is a
fairly simple answer but I am somewhat "query challenged". An average of
the number seen on all dates would be great.
Thanks,
Jackie L Preston MD