S
Somecallmejosh
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?
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?