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:
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.
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.
