|
Jon,
Crosstab query given below should be able to provide the
desired record-source for your report. T_Schedule is the name of table.
Best wishes,
A.D.Tejpal
====================================
TRANSFORM First(T_Schedule.Client) AS
FirstOfClient
SELECT T_Schedule.Therapist, T_Schedule.StartTime
FROM
T_Schedule
GROUP BY T_Schedule.Therapist, T_Schedule.StartTime
ORDER BY
T_Schedule.Therapist, T_Schedule.StartTime
PIVOT T_Schedule.Weekday In
("Mon","Tue","Wed","Thu","Fri","Sat","Sun");
====================================
----- Original Message -----
Sent: Thursday, July 07, 2005 05:07
Subject: Re: [AccessDevelopers] Re:
Report Help Requested
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 ...
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
& gt; 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
|
