Chris,
I have been trying for about a week, and I cannot figure it out ...
Hopefully sharper minds will prevail.
I do appreciate your efforts to this end ...
Jon
chrisman052003 <[EMAIL PROTECTED]> wrote:
chrisman052003 <[EMAIL PROTECTED]> wrote:
I played around a little with this today with not much luck. I know
the answer is in the syntax of the query. I'll keep trying, but I
know there are much more knowledgable folks on this list serve who
can answer this off the top of their head.
Chris
--- In AccessDevelopers@yahoogroups.com, Jonathan Smith
<[EMAIL PROTECTED]> wrote:
> Chris,
>
> Thank you for the insight, I have looked at your suggestions.
>
> Here is the problem, I do not want a count of the number of
appointments, I want to display the Client Name ...
>
> Any suggestions?
>
> chrisman052003 <[EMAIL PROTECTED]> wrote:
> First, you should consider breaking your table into 3 separate
> tables. 1 for clients, 1 for therapists, and 1 for appointments.
You
> also have to consider the date itself becasue there are 52
Monday's
> in a year, 52 Tuesdays, etc. and I would think you want to create
a
> report that shows "this weeks appointments." The way your table
is
> now, every time you run a report your going to get every Monday,
> Tuesday, etc. appointment.
> If you look at the Northwind database, look at the tables and
you'll
> see there is customer (your Clients), employee (your Therapist)
and
> orders ( your appointments). Then look at the Query Employee
Sales
> by Country. This query is the record source for the report
Employee
> Sales by Country. Then click on Employee Sales by Country. This
is
> similar to what your looking for.
> Chris
> <[EMAIL PROTECTED]> wrote:
> > I am utilzing Access 2003, and have the need to create a
Schedule
> > Report. Unfortunately, I cannot figure out how to get it to
> work ...
> >
> > Table Schema
> >
> > Client Text
> > Therapist Text
> > Weekday Text
> > StartTime Date/Time
> >
> > Here is the layout I seek to create:
> >
> > Therapist: xxxxxxx
> >
> > Start Day of Week
> > Time Monday Tuesday Wednesday Thursday
> Friday
> > 8:00 Client Client Client Client
> Client
> > 9:00 Client Client Client Client
> Client
> > 10:00
> > 11:00
> > 12:00
> >
> >
> > I would like to FILTER REPORT on Therapist Name, and have the
> Client
> > Name appear in the appropriate "CELL" of the StartTime and
Weekday
> > intersect ...
> >
> > I have no idea how to do this ....
> >
> > Any suggestions???
> >
> > Thank you.
>
>
>
>
>
> Please zip all files prior to uploading to Files section.
>
>
>
> ---------------------------------
> YAHOO! GROUPS LINKS
>
>
> Visit your group "AccessDevelopers" on the web.
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
> ---------------------------------
Please zip all files prior to uploading to Files section.
Please zip all files prior to uploading to Files section.
YAHOO! GROUPS LINKS
- Visit your group "AccessDevelopers" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
