Query is not reflecting all records.

[Guest]

I used fields from three different tables to build a query.

Table 1: Investor Name & Investor Category
Table 2: General Information, Source, Date
Table 3: Activity, Source, Date

Fields from Table 1 will always be populated. However, not all records will
contain data for Gen Info AND Activity; sometimes a record will contain data
for only one or the other.

My problem, as you might guess, is that not all of my records are reflecting
in my query when I run it. I understand that ‘join types’ deal with this
issue. The Join Properties box provides 3 options: 1) only include rows
where the joined fields from both tables are equal (this is the default), 2)
includes ALL records from ‘Left Table Name’ and only those records from
‘Right Table Name’ where the joined fields are equal, and 3) includes ALL
records from ‘Right Table Name’ and only those records from ‘Left Table Name’
where the joined fields are equal. What I actually need is an option that
says: include all Investor Names, even if some or all of the fields from the
other tables are empty. Options 2 or 3 above would help me if I was dealing
with only 2 tables, but since I have 3, I seem to be up a creek. Does anyone
have any ideas? I'm an Access newby, so please respond using simple terms.
Thanks for your time!

 

[Marshall Barton]

I used fields from three different tables to build a query.

Table 1: Investor Name & Investor Category
Table 2: General Information, Source, Date
Table 3: Activity, Source, Date

Fields from Table 1 will always be populated. However, not all records will
contain data for Gen Info AND Activity; sometimes a record will contain data
for only one or the other.

My problem, as you might guess, is that not all of my records are reflecting
in my query when I run it. I understand that ‘join types’ deal with this
issue. The Join Properties box provides 3 options: 1) only include rows
where the joined fields from both tables are equal (this is the default), 2)
includes ALL records from ‘Left Table Name’ and only those records from
‘Right Table Name’ where the joined fields are equal, and 3) includes ALL
records from ‘Right Table Name’ and only those records from ‘Left Table Name’
where the joined fields are equal. What I actually need is an option that
says: include all Investor Names, even if some or all of the fields from the
other tables are empty. Options 2 or 3 above would help me if I was dealing
with only 2 tables, but since I have 3, I seem to be up a creek.

When you add the three tables to the top part of the query
window, remove any lines that were drawn automatically. I
suspect that Access is automatically connecting table 2 to
table 3 on the source field, which is not what you want.

Then drag the connecting field (source?) from table 2 to
corresponding field (investor name?) in table 1, right click
the line and select the join type that includes all records
from table1 and any matching records in table 2. Repeat
those steps for the field from table 3 to table 1.

 

[Guest]

Marsh! You are awesome. You're advice worked! Thank you sooo much!

Regards,
Jill

 

[Guest]

Okay, I started entering my records, ran the query again to make sure all was
well, and unfortunately, noticed a problem. My query is duplicating
information. For instance, say I have two "General Information" records and
one "Activity" record linked to one Investor. When I run the query, it
reflects the Investor name, followed by one General Information entry,
followed by one (the only) Activity entry. Then grouped under this, it shows
the Investor name again, followed by the 2nd Gen Info entry, followed the
Activity entry again -- a second time. Ideally, the query would reflect the
Investor name once, followed by the two Gen Info entries and the "one"
Activity entry. I'm sure I'm not explaining well. If you can help at all, I
would appreciate it. Thanks!!

 

[Marshall Barton]

Queries don't work that way. What you're looking for now is
a way to present the data in a nicely formatted way. This
is what reports are good at (and to a lesser degree forms).

If you would use a report, then you would either group on an
identifier field for each group of data or use two (or more)
queries and subreports to help organize the data. If you
use a form. you would use one or more subforms.

 

[Guest]

Hi, sorry to bother you again. I tried to create a report via the Report
Wizard. I arrived to the spot in the wizard where I could add grouping. I
wanted to group by Investor Name, then by General Information, then by
Activity. However, neither Gen Info or Activity appeared as grouping options
in the window. I'm certain that each of these fields are included in my
query. I really didn't want to bother you again today. I've spent much of
today reading manuals. I just can't figure this out. Can you offer any
ideas? Thanks M!

Queries don't work that way. What you're looking for now is
a way to present the data in a nicely formatted way. This
is what reports are good at (and to a lesser degree forms).

If you would use a report, then you would either group on an
identifier field for each group of data or use two (or more)
queries and subreports to help organize the data. If you
use a form. you would use one or more subforms.
--
Marsh
MVP [MS Access]

Okay, I started entering my records, ran the query again to make sure all was
well, and unfortunately, noticed a problem. My query is duplicating
information. For instance, say I have two "General Information" records and
one "Activity" record linked to one Investor. When I run the query, it
reflects the Investor name, followed by one General Information entry,
followed by one (the only) Activity entry. Then grouped under this, it shows
the Investor name again, followed by the 2nd Gen Info entry, followed the
Activity entry again -- a second time. Ideally, the query would reflect the
Investor name once, followed by the two Gen Info entries and the "one"
Activity entry. I'm sure I'm not explaining well. If you can help at all, I
would appreciate it. Thanks!!

 

[Marshall Barton]

I hope this is not overwhelming you, but the wizards are
probably limiting your ability to make the adjustments you
want. Let's try it the hard way ;-)

Open the report in design view. Use the View menu to
display the Fields List and the Sorting and Grouping window.

You can then look at the field list to make sure the fields
are really there. If not, then adjust the record source
query to include them.

You can look at the record source query by double clicking
in the upper left corner of the report design above and to
the left of the rulers. The record aource property is the
first one under the Data or All tab. If you do need to make
adjustments, then click on the builder button [...] in the
right margin of the property to see the query in query
design view.

Once the right fields are available, go to the Sorting and
Grouping window and select Investor Name in the top row,
General Info in the second row and Activity in the third
row. If you want a group header or footer for any of the
groups, then set the property in the lower part of the
window.

 

[Guest]

Hi Marsh, thanks for responding! I did as you advised below to verify that
the record source property does contain all fields. It does, the query looks
perfect. However, when I open the sorting and grouping window, 2 of the 8
fields do not appear. Argh! I'm completely boggled. Is there anything else
I can try? The two fields that are not showing up are memo fields, while the
fields that are showing up are text fields -- could this have anything to do
with the problems I'm having?

I hope this is not overwhelming you, but the wizards are
probably limiting your ability to make the adjustments you
want. Let's try it the hard way ;-)

Open the report in design view. Use the View menu to
display the Fields List and the Sorting and Grouping window.

You can then look at the field list to make sure the fields
are really there. If not, then adjust the record source
query to include them.

You can look at the record source query by double clicking
in the upper left corner of the report design above and to
the left of the rulers. The record aource property is the
first one under the Data or All tab. If you do need to make
adjustments, then click on the builder button [...] in the
right margin of the property to see the query in query
design view.

Once the right fields are available, go to the Sorting and
Grouping window and select Investor Name in the top row,
General Info in the second row and Activity in the third
row. If you want a group header or footer for any of the
groups, then set the property in the lower part of the
window.
--
Marsh
MVP [MS Access]

Hi, sorry to bother you again. I tried to create a report via the Report
Wizard. I arrived to the spot in the wizard where I could add grouping. I
wanted to group by Investor Name, then by General Information, then by
Activity. However, neither Gen Info or Activity appeared as grouping options
in the window. I'm certain that each of these fields are included in my
query. I really didn't want to bother you again today. I've spent much of
today reading manuals. I just can't figure this out. Can you offer any
ideas? Thanks M!

 

[Marshall Barton]

Hi Marsh, thanks for responding! I did as you advised below to verify that
the record source property does contain all fields. It does, the query looks
perfect. However, when I open the sorting and grouping window, 2 of the 8
fields do not appear. Argh! I'm completely boggled. Is there anything else
I can try? The two fields that are not showing up are memo fields, while the
fields that are showing up are text fields -- could this have anything to do
with the problems I'm having?

Ahhh. yes, that's it. Memo fields can not be sorted or
grouped. They can be way too long to make sense in those
operations.

It's difficult for me to imagine why you would want to do
that. A field with potentially that much data should be
unique so there's no real purpose in grouping on it. Most
likely, you can sort on the expression
=Left(memofield, 250)
and get just as good a result.

 

[Guest]

Okay, let me explain my project. We have been collecting articles regarding
certain potential investors. I have been typing relevant info (i.e. "General
Information" and "Activity" information) obtained from these articles into a
MS Word table. This table is growing, and looking more and more obnoxious.
I thought maybe it would be more efficient to maintain this info in Access.
Some of the articles are lengthy, I need more than 255 characters, which is
why I chose memo rather than text data types. I've spent a lot of time
creating tables, forms, entering data, etc; however, it may have been for
nothing if I can't create a report that resembles the table we created in
Word. I thought my objective was fairly simple. I may have thought wrong.
(

 

[Marshall Barton]

I don't see anything wrong with your objective, but I also
don't see how grouping a report on a memo field helps
achieve the objective.

Maybe I need to back up a little and make sure I understand
the report layout you want to achieve, the fields in the
report's record source table/query and where the memo fields
fit into the picture.

 

[Guest]

Hi Marsh, I thought you gave up on me (I wouldn't blame you ). I just
finished placing a post for the Reports discussion group. I'll paste it here
for you, I think (I hope) it gives a clear summary of what I'm trying to do
and the problems I'm having.

"My objective is to create a report based on a query that includes the
fields ndicated below:

Table One Fields: 1) Investor Name
Table Two Fields: 1) General Information, 2) GI Source, and 3) GI Date
Table Three Fields: 1) Activity, 2) Act Source, and 3) Act Date

The General Information and Activity fields are memo fields. We are placing
article excerpts in these fields, most excerpts are lengthier than 255
characters, which is why we must use memo, not text, data types.

We wish to design our report to reflect as follows:

Investor Name (ABC Company) to populate first

Followed by a grouping of all Gen Info records linked to ABC Company, sorted
in date order (i.e. article excerpt #1, it’s source, it’s date; article
excerpt #2, it’s source, it’s date; etc.)

Followed by a grouping of all Activity records linked to ABC Company, sorted
in date order (i.e. article excerpt #1, it’s source, it’s date; article
excerpt #2, it’s source, it’s date; etc.)

I tried to create the above, but the report was full of empty boxes and
duplicate data. I think my problems stem from a Grouping issue. However,
the fields I want to group by are not grouping options since they have memo
data types."

Marsh, if some details are still foggy, please let me know. You are
thinking that maybe I don't need to group by General Information and
Activity? You are the only one who has been brave enough to try to help me.
Thank you! )

Jill

I don't see anything wrong with your objective, but I also
don't see how grouping a report on a memo field helps
achieve the objective.

Maybe I need to back up a little and make sure I understand
the report layout you want to achieve, the fields in the
report's record source table/query and where the memo fields
fit into the picture.
--
Marsh
MVP [MS Access]

Okay, let me explain my project. We have been collecting articles regarding
certain potential investors. I have been typing relevant info (i.e. "General
Information" and "Activity" information) obtained from these articles into a
MS Word table. This table is growing, and looking more and more obnoxious.
I thought maybe it would be more efficient to maintain this info in Access.
Some of the articles are lengthy, I need more than 255 characters, which is
why I chose memo rather than text data types. I've spent a lot of time
creating tables, forms, entering data, etc; however, it may have been for
nothing if I can't create a report that resembles the table we created in
Word. I thought my objective was fairly simple. I may have thought wrong.
(

 

[Marshall Barton]

Hi Marsh, I thought you gave up on me (I wouldn't blame you ). I just
finished placing a post for the Reports discussion group. I'll paste it here
for you, I think (I hope) it gives a clear summary of what I'm trying to do
and the problems I'm having.

"My objective is to create a report based on a query that includes the
fields ndicated below:

Table One Fields: 1) Investor Name
Table Two Fields: 1) General Information, 2) GI Source, and 3) GI Date
Table Three Fields: 1) Activity, 2) Act Source, and 3) Act Date

The General Information and Activity fields are memo fields. We are placing
article excerpts in these fields, most excerpts are lengthier than 255
characters, which is why we must use memo, not text, data types.

We wish to design our report to reflect as follows:

Investor Name (ABC Company) to populate first

Followed by a grouping of all Gen Info records linked to ABC Company, sorted
in date order (i.e. article excerpt #1, it’s source, it’s date; article
excerpt #2, it’s source, it’s date; etc.)

Followed by a grouping of all Activity records linked to ABC Company, sorted
in date order (i.e. article excerpt #1, it’s source, it’s date; article
excerpt #2, it’s source, it’s date; etc.)

I tried to create the above, but the report was full of empty boxes and
duplicate data. I think my problems stem from a Grouping issue. However,
the fields I want to group by are not grouping options since they have memo
data types."

Marsh, if some details are still foggy, please let me know. You are
thinking that maybe I don't need to group by General Information and
Activity? You are the only one who has been brave enough to try to help me.

Well, I may need more information about the Act Source and
GI Source fields, but I think the big problem is the way you
are thinking about grouping. If you want a grouping of data
records, you need to specify the field that has a common
value for every record in the group. In this case it is the
[Investor Name] field that defines the group. The memo
fields are just data that varies within the group.

To separate your general information data from the activity
data we would have to get tricky with the report's record
source query.

It would be a lot easier to use a subreport for general
information and another subreport for activity so you would
not even need to specify any grouping in the main report.

Whichever way you want to do it, it is critical that the
general information and activity tables have a foreign key
field to link their records to the corresponding record in
the investors table.

 

[Guest]

Sorry for being so wordy, I'm just trying to explain clearly.

The Investors table (my primary table) includes a primary key auto number
field I named "ID". The Gen Info and Activity tables each have foreign key
number fields also named "ID". The foreign key in each of these tables are
linked to the primary key in the Investors table to form one-to-many
relationships. Sound good to you? Okay, so I tried your subreports idea. I
needed a way to link the subreports to the main report. So I added the
matching keys from each of the 3 tables to the report source/query. I
created a General Info report with consisted of only the ID, Gen Info, Date &
Source fields. I created a second similar report for the Activity fields.
Then I created a Main report that includes ID, Investor Name and Investor
Category. I placed the Gen Info and Activity report inside the Detail
section of the Main report via the subreport control (used the subreport icon
in the toolbox). The subreport wizard asked me if I wanted to "define which
fields link my main form to the subform myself, or choose from the list
below. The listed options were cut off since they were displayed in a fixed
width window, I could not read them entirely. So I chose to define my own.
For Form/Report field, I chose "ID" from the Investors table; and for
Subreport field I chose "ID" from the Gen Info table for the Gen Info
subreport and, obviously, "ID" from the Activity table for the Activity
subreport. Sound ok so far? When I finished, I tried to switch from Design
View to Print Preview and received a box that was titled "enter value
parameter" -- it contained a field for me to type in and was labeled 01 -
Investors. What does this mean? Any guesses?

Hi Marsh, I thought you gave up on me (I wouldn't blame you ). I just
finished placing a post for the Reports discussion group. I'll paste it here
for you, I think (I hope) it gives a clear summary of what I'm trying to do
and the problems I'm having.

"My objective is to create a report based on a query that includes the
fields ndicated below:

Table One Fields: 1) Investor Name
Table Two Fields: 1) General Information, 2) GI Source, and 3) GI Date
Table Three Fields: 1) Activity, 2) Act Source, and 3) Act Date

The General Information and Activity fields are memo fields. We are placing
article excerpts in these fields, most excerpts are lengthier than 255
characters, which is why we must use memo, not text, data types.

We wish to design our report to reflect as follows:

Investor Name (ABC Company) to populate first

Followed by a grouping of all Gen Info records linked to ABC Company, sorted
in date order (i.e. article excerpt #1, it’s source, it’s date; article
excerpt #2, it’s source, it’s date; etc.)

Followed by a grouping of all Activity records linked to ABC Company, sorted
in date order (i.e. article excerpt #1, it’s source, it’s date; article
excerpt #2, it’s source, it’s date; etc.)

I tried to create the above, but the report was full of empty boxes and
duplicate data. I think my problems stem from a Grouping issue. However,
the fields I want to group by are not grouping options since they have memo
data types."

Marsh, if some details are still foggy, please let me know. You are
thinking that maybe I don't need to group by General Information and
Activity? You are the only one who has been brave enough to try to help me.

Well, I may need more information about the Act Source and
GI Source fields, but I think the big problem is the way you
are thinking about grouping. If you want a grouping of data
records, you need to specify the field that has a common
value for every record in the group. In this case it is the
[Investor Name] field that defines the group. The memo
fields are just data that varies within the group.

To separate your general information data from the activity
data we would have to get tricky with the report's record
source query.

It would be a lot easier to use a subreport for general
information and another subreport for activity so you would
not even need to specify any grouping in the main report.

Whichever way you want to do it, it is critical that the
general information and activity tables have a foreign key
field to link their records to the corresponding record in
the investors table.

 

[Marshall Barton]

Sorry for being so wordy, I'm just trying to explain clearly.

The Investors table (my primary table) includes a primary key auto number
field I named "ID". The Gen Info and Activity tables each have foreign key
number fields also named "ID". The foreign key in each of these tables are
linked to the primary key in the Investors table to form one-to-many
relationships. Sound good to you? Okay, so I tried your subreports idea. I
needed a way to link the subreports to the main report. So I added the
matching keys from each of the 3 tables to the report source/query. I
created a General Info report with consisted of only the ID, Gen Info, Date &
Source fields. I created a second similar report for the Activity fields.
Then I created a Main report that includes ID, Investor Name and Investor
Category. I placed the Gen Info and Activity report inside the Detail
section of the Main report via the subreport control (used the subreport icon
in the toolbox). The subreport wizard asked me if I wanted to "define which
fields link my main form to the subform myself, or choose from the list
below. The listed options were cut off since they were displayed in a fixed
width window, I could not read them entirely. So I chose to define my own.
For Form/Report field, I chose "ID" from the Investors table; and for
Subreport field I chose "ID" from the Gen Info table for the Gen Info
subreport and, obviously, "ID" from the Activity table for the Activity
subreport. Sound ok so far? When I finished, I tried to switch from Design
View to Print Preview and received a box that was titled "enter value
parameter" -- it contained a field for me to type in and was labeled 01 -
Investors. What does this mean? Any guesses?

That means that you have a reference to something named
[01 - Investors], either you fogot to include that field in
a query or it's a typo in a record source query or in a text
box control source. Do you have a field named anything like
that?

 

[Guest]

I don't have a field named 01 - Investors, but 01 - Investors is the name of
my primary table. This table has only 3 fields, and they are all included in
the query that I'm using to build my report. Maybe I should just throw my pc
out the window -- that would make me feel really good.

Sorry for being so wordy, I'm just trying to explain clearly.

The Investors table (my primary table) includes a primary key auto number
field I named "ID". The Gen Info and Activity tables each have foreign key
number fields also named "ID". The foreign key in each of these tables are
linked to the primary key in the Investors table to form one-to-many
relationships. Sound good to you? Okay, so I tried your subreports idea. I
needed a way to link the subreports to the main report. So I added the
matching keys from each of the 3 tables to the report source/query. I
created a General Info report with consisted of only the ID, Gen Info, Date &
Source fields. I created a second similar report for the Activity fields.
Then I created a Main report that includes ID, Investor Name and Investor
Category. I placed the Gen Info and Activity report inside the Detail
section of the Main report via the subreport control (used the subreport icon
in the toolbox). The subreport wizard asked me if I wanted to "define which
fields link my main form to the subform myself, or choose from the list
below. The listed options were cut off since they were displayed in a fixed
width window, I could not read them entirely. So I chose to define my own.
For Form/Report field, I chose "ID" from the Investors table; and for
Subreport field I chose "ID" from the Gen Info table for the Gen Info
subreport and, obviously, "ID" from the Activity table for the Activity
subreport. Sound ok so far? When I finished, I tried to switch from Design
View to Print Preview and received a box that was titled "enter value
parameter" -- it contained a field for me to type in and was labeled 01 -
Investors. What does this mean? Any guesses?

That means that you have a reference to something named
[01 - Investors], either you fogot to include that field in
a query or it's a typo in a record source query or in a text
box control source. Do you have a field named anything like
that?

 

[Marshall Barton]

Yeah, these darn computers just won't tolerate any mistakes
we might make. It would be so much nicer if they would do
what we wanted instead of what we tell them to do ;-)

First, if you are using a query based on that table as the
record source for the report, open the query by itself. If
you get the prompt, then the typo is in the query.

If the query is ok, then look at the control source property
of the text boxes in the report based on that table. Check
each carefully for that string.
--
Marsh
MVP [MS Access]

I don't have a field named 01 - Investors, but 01 - Investors is the name of
my primary table. This table has only 3 fields, and they are all included in
the query that I'm using to build my report. Maybe I should just throw my pc
out the window -- that would make me feel really good.

That means that you have a reference to something named
[01 - Investors], either you fogot to include that field in
a query or it's a typo in a record source query or in a text
box control source. Do you have a field named anything like
that?

 

[Guest]

Marsh! I tried some things while I was waiting for you to respond this
morning. I don't know what I did exactly, but it was good -- because now the
goofy thing is working! I scrapped my original query where I had added
fields from my 3 tables. I created 3 new queries, a separate one for each of
the three tables. Then I created 3 reports based on each of the new queries.
For whatever reason, Access likes this better. Yeah, I'm so happy! )
The only design change I would make now, if I could, would be to tell Access
to hide empty fields in the report. For example: the subreports are fixed
at least 1" high (hopefully it will grow as needed). Not every Investor
record is populated by both Gen Info AND Activity data. Sometimes only the
Gen Info fields will be populated or only the Activity fields. The report is
reflecting both subreports for every Investor regardless of whether or not
the subreports contain data. So, I'm getting a lot of empty boxes, which is
causing lots of space/paper waste. Any ideas? If we can just button up this
last loose issue, I think we'll finally have this thing finished. Thanks for
EVERYTHING Marsh, you're a very smart and patient man! There would be many
less databases in the world without people like you!

Yeah, these darn computers just won't tolerate any mistakes
we might make. It would be so much nicer if they would do
what we wanted instead of what we tell them to do ;-)

First, if you are using a query based on that table as the
record source for the report, open the query by itself. If
you get the prompt, then the typo is in the query.

If the query is ok, then look at the control source property
of the text boxes in the report based on that table. Check
each carefully for that string.
--
Marsh
MVP [MS Access]

I don't have a field named 01 - Investors, but 01 - Investors is the name of
my primary table. This table has only 3 fields, and they are all included in
the query that I'm using to build my report. Maybe I should just throw my pc
out the window -- that would make me feel really good.

Jill76 wrote:
The Investors table (my primary table) includes a primary key auto number
field I named "ID". The Gen Info and Activity tables each have foreign key
number fields also named "ID". The foreign key in each of these tables are
linked to the primary key in the Investors table to form one-to-many
relationships. Sound good to you? Okay, so I tried your subreports idea. I
needed a way to link the subreports to the main report. So I added the
matching keys from each of the 3 tables to the report source/query. I
created a General Info report with consisted of only the ID, Gen Info, Date &
Source fields. I created a second similar report for the Activity fields.
Then I created a Main report that includes ID, Investor Name and Investor
Category. I placed the Gen Info and Activity report inside the Detail
section of the Main report via the subreport control (used the subreport icon
in the toolbox). The subreport wizard asked me if I wanted to "define which
fields link my main form to the subform myself, or choose from the list
below. The listed options were cut off since they were displayed in a fixed
width window, I could not read them entirely. So I chose to define my own.
For Form/Report field, I chose "ID" from the Investors table; and for
Subreport field I chose "ID" from the Gen Info table for the Gen Info
subreport and, obviously, "ID" from the Activity table for the Activity
subreport. Sound ok so far? When I finished, I tried to switch from Design
View to Print Preview and received a box that was titled "enter value
parameter" -- it contained a field for me to type in and was labeled 01 -
Investors. What does this mean? Any guesses?

That means that you have a reference to something named
[01 - Investors], either you fogot to include that field in
a query or it's a typo in a record source query or in a text
box control source. Do you have a field named anything like
that?

 

[Marshall Barton]

Marsh! I tried some things while I was waiting for you to respond this
morning. I don't know what I did exactly, but it was good -- because now the
goofy thing is working! I scrapped my original query where I had added
fields from my 3 tables. I created 3 new queries, a separate one for each of
the three tables. Then I created 3 reports based on each of the new queries.
For whatever reason, Access likes this better. Yeah, I'm so happy! )
The only design change I would make now, if I could, would be to tell Access
to hide empty fields in the report. For example: the subreports are fixed
at least 1" high (hopefully it will grow as needed). Not every Investor
record is populated by both Gen Info AND Activity data. Sometimes only the
Gen Info fields will be populated or only the Activity fields. The report is
reflecting both subreports for every Investor regardless of whether or not
the subreports contain data. So, I'm getting a lot of empty boxes, which is
causing lots of space/paper waste. Any ideas? If we can just button up this
last loose issue, I think we'll finally have this thing finished. Thanks for
EVERYTHING Marsh, you're a very smart and patient man! There would be many
less databases in the world without people like you!

Hoo Rah! Some serious progress ;-)

Make sure that the text boxes in the subreport's detail
section and the detail section itself all have their CanGrow
and CanShrink properties set to Yes. Then, also set the
subreport control (on the main report) CanGrow and CanShrink
properties to Yes.

It also sounds like you forgot to set the subreport
control's Link Master/Child properties to the linking field.