Re: Too many queries
From: Duane Hookom (duanehookom_at_NoSpamHotmail.com)
Date: 10/26/04
- Next message: Douglas J. Steele: "Re: Trim Email Address down to domain only"
- Previous message: Randal: "Help with simple delete query"
- In reply to: Somecallmejosh: "Too many queries"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 26 Oct 2004 16:35:59 -0500
What is your current table structure(s)? What you want to see on a
form/screen/report should never drive how your tables are structured.
-- Duane Hookom MS Access MVP -- "Somecallmejosh" <anonymous@discussions.microsoft.com> wrote in message news:1b2a01c4bb91$84ee2c70$a301280a@phx.gbl... > Hello, > > Situation: I am setting up a database for a dance > studio. One of my tables pertains to scheduling. There > are three studios, and there are three classes taught in > the evening every afternoon. I have my class scheduling > table set up so that it pulls in the teacher name and > class name (lookups).... additional fields would include > each day of the week [Monday], [Tuesday], etc... as > yes/no... [Studio] for each day and [Time of class] for > studio for each day. Yes, lots of variables for each > given day. I have it set up this way because it allows > me to group all class information together. As opposed > to splitting the classes on multiple forms, this way > allows me to select all pertinent information on one form > (I hope this makes sense). > > This forces me into a difficult situation however, > whenever setting up a query to show the time, studio, > teacher, and student enrollment(from [Student] table), in > each class, based off of the studio and time class is > taught. Because there are nine possibilities for class > and studio time combinations I have been forced to create > 45 different queries, and generate 45 different reports > (classes are 5 days a week). I can't do a parameter > query on the studio becuase there are three studio > occurences associated with three different time > possibilities for 5 days worth of classes. I have > obviously approached this from the wrong angle. Is there > a better alternative in terms of a parameter query or do > I need to restructure my table? > > I'm sure this is old hat, but is there a better way to > set up my table and queries to accomodate for the > scheduling of classes, instructors, and students; for > three different time periods, three different studios, > over the course of 5 days?
- Next message: Douglas J. Steele: "Re: Trim Email Address down to domain only"
- Previous message: Randal: "Help with simple delete query"
- In reply to: Somecallmejosh: "Too many queries"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
