Report Source

The db is set up with the following tables:

TblSchool
School ID
contains the name, addres, contact information of the school

TblOrg
OrgID
contains contact information of purchasing organization

TblRes
Res ID
School ID
field-Program Type
field-Res Type
also identifies residency information, cost, time

Please advise why you are suggesting that the additional tables (TblProgram
and TblProgramResidency) need to be added to this design?


Tbl



"Steve" wrote:

As suspected, your report problem stems from incorrect tables. Conside this
design:

TblSchool
SchoolID
School Attributes

TblProgram
ProgramID
Program

TblResidency
ResidencyID
Residency

TblProgramResidency
ProgramResidencyID
ProgramID
ResidencyID

TblSchoolProgramResidency
SchoolProgramResidencyID
SchoolID
ProgramResidencyID

Study these tables then give me any questions you have about the tables.
Once we resolve the design of the tables, then you need to reword your two
questions relative to the above tables.

Steve


"Darlene" wrote in message
...
We have multiply schools that purchase three types of programs (Dance,
Theatre, or Early Learning), which are all listed under the field
"Programs"
in the table. Each Dance or Theatre program has a specific type of
program
(ex. Dance - Tap, Theater - Poetry) called residencies. For the document
we
need to indicate that either a dance or theatre program was purchased as
well
as how many residencies for each program per school.

1. How can the information pertaining to that program be programmed to
show
up in the appropriate column?


Type of Residency Program (s) Early Learning Through the Arts Arts Academy
in «Program»

Discipline «Residency_Type»
«Residency_Type»


2. How can the number of residencies from a specific school be calculated
for a specific program and appear in the table below?

Arts Academy «Program» -
(# of) Residency(ies)
Early Learning - (# of) Residency(ies)



"Steve" wrote:

Darlene,

Before you spend too much time possibly going down the wrong road, show
us
your tables and fields and tell us why you asked the question.

Steve



"Darlene" wrote in message
...
Thank you to ALLL... We will research "Sub-Reports" and "Union Queries"
to
test this process.

"Darlene" wrote:

Is it possible to have more than one query supply information to a
report?
If so, how can this process be done?

Darlene

Remember that the information you receive here is coming from folks with
widely-varying expertise and motivation.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Darlene" wrote in message
...
The db is set up with the following tables:

TblSchool
School ID
contains the name, addres, contact information of the school

TblOrg
OrgID
contains contact information of purchasing organization

TblRes
Res ID
School ID
field-Program Type
field-Res Type
also identifies residency information, cost, time

Please advise why you are suggesting that the additional tables
(TblProgram
and TblProgramResidency) need to be added to this design?


Tbl



"Steve" wrote:

As suspected, your report problem stems from incorrect tables. Conside
this
design:

TblSchool
SchoolID
School Attributes

TblProgram
ProgramID
Program

TblResidency
ResidencyID
Residency

TblProgramResidency
ProgramResidencyID
ProgramID
ResidencyID

TblSchoolProgramResidency
SchoolProgramResidencyID
SchoolID
ProgramResidencyID

Study these tables then give me any questions you have about the tables.
Once we resolve the design of the tables, then you need to reword your
two
questions relative to the above tables.

Steve


"Darlene" wrote in message
...
We have multiply schools that purchase three types of programs (Dance,
Theatre, or Early Learning), which are all listed under the field
"Programs"
in the table. Each Dance or Theatre program has a specific type of
program
(ex. Dance - Tap, Theater - Poetry) called residencies. For the
document
we
need to indicate that either a dance or theatre program was purchased
as
well
as how many residencies for each program per school.

1. How can the information pertaining to that program be programmed to
show
up in the appropriate column?


Type of Residency Program (s) Early Learning Through the Arts Arts
Academy
in «Program»

Discipline «Residency_Type»
«Residency_Type»


2. How can the number of residencies from a specific school be
calculated
for a specific program and appear in the table below?

Arts Academy «Program» -
(# of) Residency(ies)
Early Learning - (# of) Residency(ies)



"Steve" wrote:

Darlene,

Before you spend too much time possibly going down the wrong road,
show
us
your tables and fields and tell us why you asked the question.

Steve



"Darlene" wrote in message
...
Thank you to ALLL... We will research "Sub-Reports" and "Union
Queries"
to
test this process.

"Darlene" wrote:

Is it possible to have more than one query supply information to a
report?
If so, how can this process be done?

Your three tables do not appear to be consistent with your original post. In
your original post you said "...three types of programs .... which are all
listed under the field Programs". I don't see a field Programs in any of
these three tables.

In your original post you said "...multiply (sp?) schools that purchase
three types of programs ...). TblOrg here seems to imply that an
organization purchases programs for the schools.

Steve



"Darlene" wrote in message
...
The db is set up with the following tables:

TblSchool
School ID
contains the name, addres, contact information of the school

TblOrg
OrgID
contains contact information of purchasing organization

TblRes
Res ID
School ID
field-Program Type
field-Res Type
also identifies residency information, cost, time

Please advise why you are suggesting that the additional tables
(TblProgram
and TblProgramResidency) need to be added to this design?


Tbl



"Steve" wrote:

As suspected, your report problem stems from incorrect tables. Conside
this
design:

TblSchool
SchoolID
School Attributes

TblProgram
ProgramID
Program

TblResidency
ResidencyID
Residency

TblProgramResidency
ProgramResidencyID
ProgramID
ResidencyID

TblSchoolProgramResidency
SchoolProgramResidencyID
SchoolID
ProgramResidencyID

Study these tables then give me any questions you have about the tables.
Once we resolve the design of the tables, then you need to reword your
two
questions relative to the above tables.

Steve


"Darlene" wrote in message
...
We have multiply schools that purchase three types of programs (Dance,
Theatre, or Early Learning), which are all listed under the field
"Programs"
in the table. Each Dance or Theatre program has a specific type of
program
(ex. Dance - Tap, Theater - Poetry) called residencies. For the
document
we
need to indicate that either a dance or theatre program was purchased
as
well
as how many residencies for each program per school.

1. How can the information pertaining to that program be programmed to
show
up in the appropriate column?


Type of Residency Program (s) Early Learning Through the Arts Arts
Academy
in «Program»

Discipline «Residency_Type»
«Residency_Type»


2. How can the number of residencies from a specific school be
calculated
for a specific program and appear in the table below?

Arts Academy «Program» -
(# of) Residency(ies)
Early Learning - (# of) Residency(ies)



"Steve" wrote:

Darlene,

Before you spend too much time possibly going down the wrong road,
show
us
your tables and fields and tell us why you asked the question.

Steve



"Darlene" wrote in message
...
Thank you to ALLL... We will research "Sub-Reports" and "Union
Queries"
to
test this process.

"Darlene" wrote:

Is it possible to have more than one query supply information to a
report?
If so, how can this process be done?

Yes! Your and Arno's expertise and motivation is readily apparent as neither
of you offered Darlene any help. That makes both of you merely stalkers. If
you don't have any good to say, don't butt in.

Steve


"Jeff Boyce" wrote in message
...
Darlene

Remember that the information you receive here is coming from folks with
widely-varying expertise and motivation.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Darlene" wrote in message
...
The db is set up with the following tables:

TblSchool
School ID
contains the name, addres, contact information of the school

TblOrg
OrgID
contains contact information of purchasing organization

TblRes
Res ID
School ID
field-Program Type
field-Res Type
also identifies residency information, cost, time

Please advise why you are suggesting that the additional tables
(TblProgram
and TblProgramResidency) need to be added to this design?


Tbl



"Steve" wrote:

As suspected, your report problem stems from incorrect tables. Conside
this
design:

TblSchool
SchoolID
School Attributes

TblProgram
ProgramID
Program

TblResidency
ResidencyID
Residency

TblProgramResidency
ProgramResidencyID
ProgramID
ResidencyID

TblSchoolProgramResidency
SchoolProgramResidencyID
SchoolID
ProgramResidencyID

Study these tables then give me any questions you have about the tables.
Once we resolve the design of the tables, then you need to reword your
two
questions relative to the above tables.

Steve


"Darlene" wrote in message
...
We have multiply schools that purchase three types of programs (Dance,
Theatre, or Early Learning), which are all listed under the field
"Programs"
in the table. Each Dance or Theatre program has a specific type of
program
(ex. Dance - Tap, Theater - Poetry) called residencies. For the
document
we
need to indicate that either a dance or theatre program was purchased
as
well
as how many residencies for each program per school.

1. How can the information pertaining to that program be programmed to
show
up in the appropriate column?


Type of Residency Program (s) Early Learning Through the Arts Arts
Academy
in «Program»

Discipline «Residency_Type»
«Residency_Type»


2. How can the number of residencies from a specific school be
calculated
for a specific program and appear in the table below?

Arts Academy «Program» -
(# of) Residency(ies)
Early Learning - (# of) Residency(ies)



"Steve" wrote:

Darlene,

Before you spend too much time possibly going down the wrong road,
show
us
your tables and fields and tell us why you asked the question.

Steve



"Darlene" wrote in message
...
Thank you to ALLL... We will research "Sub-Reports" and "Union
Queries"
to
test this process.

"Darlene" wrote:

Is it possible to have more than one query supply information to a
report?
If so, how can this process be done?

Can you say "projection"?

Jeff

"Steve" wrote in message
m...
Yes! Your and Arno's expertise and motivation is readily apparent as
neither of you offered Darlene any help. That makes both of you merely
stalkers. If you don't have any good to say, don't butt in.

Steve


"Jeff Boyce" wrote in message
...
Darlene

Remember that the information you receive here is coming from folks with
widely-varying expertise and motivation.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Darlene" wrote in message
...
The db is set up with the following tables:

TblSchool
School ID
contains the name, addres, contact information of the school

TblOrg
OrgID
contains contact information of purchasing organization

TblRes
Res ID
School ID
field-Program Type
field-Res Type
also identifies residency information, cost, time

Please advise why you are suggesting that the additional tables
(TblProgram
and TblProgramResidency) need to be added to this design?


Tbl



"Steve" wrote:

As suspected, your report problem stems from incorrect tables. Conside
this
design:

TblSchool
SchoolID
School Attributes

TblProgram
ProgramID
Program

TblResidency
ResidencyID
Residency

TblProgramResidency
ProgramResidencyID
ProgramID
ResidencyID

TblSchoolProgramResidency
SchoolProgramResidencyID
SchoolID
ProgramResidencyID

Study these tables then give me any questions you have about the
tables.
Once we resolve the design of the tables, then you need to reword your
two
questions relative to the above tables.

Steve


"Darlene" wrote in message
...
We have multiply schools that purchase three types of programs
(Dance,
Theatre, or Early Learning), which are all listed under the field
"Programs"
in the table. Each Dance or Theatre program has a specific type of
program
(ex. Dance - Tap, Theater - Poetry) called residencies. For the
document
we
need to indicate that either a dance or theatre program was purchased
as
well
as how many residencies for each program per school.

1. How can the information pertaining to that program be programmed
to
show
up in the appropriate column?


Type of Residency Program (s) Early Learning Through the Arts Arts
Academy
in «Program»

Discipline «Residency_Type»
«Residency_Type»


2. How can the number of residencies from a specific school be
calculated
for a specific program and appear in the table below?

Arts Academy «Program» -
(# of) Residency(ies)
Early Learning - (# of) Residency(ies)



"Steve" wrote:

Darlene,

Before you spend too much time possibly going down the wrong road,
show
us
your tables and fields and tell us why you asked the question.

Steve



"Darlene" wrote in message
...
Thank you to ALLL... We will research "Sub-Reports" and "Union
Queries"
to
test this process.

"Darlene" wrote:

Is it possible to have more than one query supply information to
a
report?
If so, how can this process be done?

Still no help for the Op. Again you're just stalking!

Steve


"Jeff Boyce" wrote in message
...
Can you say "projection"?

Jeff

"Steve" wrote in message
m...
Yes! Your and Arno's expertise and motivation is readily apparent as
neither of you offered Darlene any help. That makes both of you merely
stalkers. If you don't have any good to say, don't butt in.

Steve


"Jeff Boyce" wrote in message
...
Darlene

Remember that the information you receive here is coming from folks with
widely-varying expertise and motivation.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Darlene" wrote in message
...
The db is set up with the following tables:

TblSchool
School ID
contains the name, addres, contact information of the school

TblOrg
OrgID
contains contact information of purchasing organization

TblRes
Res ID
School ID
field-Program Type
field-Res Type
also identifies residency information, cost, time

Please advise why you are suggesting that the additional tables
(TblProgram
and TblProgramResidency) need to be added to this design?


Tbl



"Steve" wrote:

As suspected, your report problem stems from incorrect tables. Conside
this
design:

TblSchool
SchoolID
School Attributes

TblProgram
ProgramID
Program

TblResidency
ResidencyID
Residency

TblProgramResidency
ProgramResidencyID
ProgramID
ResidencyID

TblSchoolProgramResidency
SchoolProgramResidencyID
SchoolID
ProgramResidencyID

Study these tables then give me any questions you have about the
tables.
Once we resolve the design of the tables, then you need to reword your
two
questions relative to the above tables.

Steve


"Darlene" wrote in message
...
We have multiply schools that purchase three types of programs
(Dance,
Theatre, or Early Learning), which are all listed under the field
"Programs"
in the table. Each Dance or Theatre program has a specific type of
program
(ex. Dance - Tap, Theater - Poetry) called residencies. For the
document
we
need to indicate that either a dance or theatre program was
purchased as
well
as how many residencies for each program per school.

1. How can the information pertaining to that program be programmed
to
show
up in the appropriate column?


Type of Residency Program (s) Early Learning Through the Arts Arts
Academy
in «Program»

Discipline «Residency_Type»
«Residency_Type»


2. How can the number of residencies from a specific school be
calculated
for a specific program and appear in the table below?

Arts Academy «Program» -
(# of) Residency(ies)
Early Learning - (# of) Residency(ies)



"Steve" wrote:

Darlene,

Before you spend too much time possibly going down the wrong road,
show
us
your tables and fields and tell us why you asked the question.

Steve



"Darlene" wrote in message
...
Thank you to ALLL... We will research "Sub-Reports" and "Union
Queries"
to
test this process.

"Darlene" wrote:

Is it possible to have more than one query supply information to
a
report?
If so, how can this process be done?

Steve,

Yes that is correct, sometimes the organization can purchase for several
schools (ex. School District). Nonetheless, I am not clear on why I would
need to change my database design and add the additional tables as you
suggested. Please explain.

Thanks for all your help!!!


TblSchool
School ID
contains the name, addres, contact information of the school

TblRes
Res ID
School ID
field-Program Type **(Dance, Theatre, Early Learning)
field-Res Type (Tap, Poetry, etc)
also identifies residency information, cost, time...


"Steve" wrote:

Your three tables do not appear to be consistent with your original post. In
your original post you said "...three types of programs .... which are all
listed under the field Programs". I don't see a field Programs in any of
these three tables.

In your original post you said "...multiply (sp?) schools that purchase
three types of programs ...). TblOrg here seems to imply that an
organization purchases programs for the schools.

Steve



"Darlene" wrote in message
...
The db is set up with the following tables:

TblSchool
School ID
contains the name, addres, contact information of the school

TblOrg
OrgID
contains contact information of purchasing organization

TblRes
Res ID
School ID
field-Program Type
field-Res Type
also identifies residency information, cost, time

Please advise why you are suggesting that the additional tables
(TblProgram
and TblProgramResidency) need to be added to this design?


Tbl



"Steve" wrote:

As suspected, your report problem stems from incorrect tables. Conside
this
design:

TblSchool
SchoolID
School Attributes

TblProgram
ProgramID
Program

TblResidency
ResidencyID
Residency

TblProgramResidency
ProgramResidencyID
ProgramID
ResidencyID

TblSchoolProgramResidency
SchoolProgramResidencyID
SchoolID
ProgramResidencyID

Study these tables then give me any questions you have about the tables.
Once we resolve the design of the tables, then you need to reword your
two
questions relative to the above tables.

Steve


"Darlene" wrote in message
...
We have multiply schools that purchase three types of programs (Dance,
Theatre, or Early Learning), which are all listed under the field
"Programs"
in the table. Each Dance or Theatre program has a specific type of
program
(ex. Dance - Tap, Theater - Poetry) called residencies. For the
document
we
need to indicate that either a dance or theatre program was purchased
as
well
as how many residencies for each program per school.

1. How can the information pertaining to that program be programmed to
show
up in the appropriate column?


Type of Residency Program (s) Early Learning Through the Arts Arts
Academy
in «Program»

Discipline «Residency_Type»
«Residency_Type»


2. How can the number of residencies from a specific school be
calculated
for a specific program and appear in the table below?

Arts Academy «Program» -
(# of) Residency(ies)
Early Learning - (# of) Residency(ies)



"Steve" wrote:

Darlene,

Before you spend too much time possibly going down the wrong road,
show
us
your tables and fields and tell us why you asked the question.

Steve



"Darlene" wrote in message
...
Thank you to ALLL... We will research "Sub-Reports" and "Union
Queries"
to
test this process.

"Darlene" wrote:

Is it possible to have more than one query supply information to a
report?
If so, how can this process be done?

"Steve" wrote in message
m...
If you don't have any good to say, don't butt in.


I thought it was *well* worth saying. And it didn't break forum rules.

"Darlene" wrote in message
...


I am not clear on why I would
need to change my database design and add the additional tables as you
suggested. Please explain.



The short answer is that you haven't posted enough information about your
tables and relationships for anyone to assess whether or not your design is
sound. $teve's stock reply in situations like this is to rubbish the design
in the hope that the poster will become confused and ask for his (paid)
help. The link in Arno's post will tell you all about $teve's solicitations
for work.

The chances are that you *don't* need to redesign your app but without more
information no-one can make that assessment. I think that might be what
Jeff was driving at.

Keith.
www.keithwilby.co.uk

Thank you. Having to design this DB based on my minimal knowledge of all the
features has been a REAL challenge. I will try to express the out come I am
looking for.

In this database there are several tables, however, two of them I would like
to focus on:

TblSchool
School ID (key)
contains the name, address, contact information of the schools

TblRes
Res ID (key)
School ID
field-Program Type **(Dance, Theatre, Early Learning)
field-Res Type ** (Tap, Poetry, Ballet, etc)
also identifies residency information, cost, time...

Below is the explanation of what I am seeking to accomplish. I have
designed forms to be used as documents (example: invoices and contracts). I
will use the invoice in my explanation:

Example – Washington School purchased 2 dance residencies (1 tap, 1
ballet) and 1 theatre (1 poetry). Each residency is identified by its own
number in the table. so in the tbleRes, Washington school has purchased the
following

Res Id School ID School Program Pro-Type
1 125 Washington School Dance Tap
2 125 Washington School Dance Ballet
3 125 Washington School Theatre Poetry

Thus, the invoice (form) should read as follows:

Quantity Description Per Unit cost
Total Due
2 Dance Tap and Ballet $1.00
$2.00
1 Theater Poetry $1.00
$1.00
Total
$3.00
What I am seeking help on is how to program the individual residency
descriptions so that each residency is identified when more than one of the
same program has been purchased. In this case, the dance program has been
purchased twice, though they are different types.

I need instruction on how to program the form to look like this. By
understaning how this programming works will help resolve the same situation
I have with capturing the correct information need for the contracts.

I hope this explanation makes sense. Thank you for any help that you can
offer me!!!


"Keith Wilby" wrote:

"Darlene" wrote in message
...


I am not clear on why I would
need to change my database design and add the additional tables as you
suggested. Please explain.



The short answer is that you haven't posted enough information about your
tables and relationships for anyone to assess whether or not your design is
sound. $teve's stock reply in situations like this is to rubbish the design
in the hope that the poster will become confused and ask for his (paid)
help. The link in Arno's post will tell you all about $teve's solicitations
for work.

The chances are that you *don't* need to redesign your app but without more
information no-one can make that assessment. I think that might be what
Jeff was driving at.

Keith.
www.keithwilby.co.uk