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 [email protected], 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. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
