Subreport

[Guest]

I have a report which has many records for each File # and need to add a
subreport because the data I need to display on the report has only 1 record
for each File #. I have inserted the subreport with the links as follows,
but I cannot get any of the data from the subreport to display on my report.
What am I doing wrong?

Child Field: File #;C Month (This comes from a Table)
Master Field: File #;Month (Main report - data from qry)

 

[Duane Hookom]

I would expect that since you (or someone else) has chosen to use symbols
and/or spaces in field/column names, you need to enclose these in []s. Make
sure the data types are the same.

 

[Guest]

Hi Duane,
I have changed the links to the following and also verified the data types
are the same, but still receive no data for my subreport. Do you have any
other suggestions?

Child Field: [File #];C Month (This comes from a Table)
Master Field: [File #];Month (Main report - data from qry)

I would expect that since you (or someone else) has chosen to use symbols
and/or spaces in field/column names, you need to enclose these in []s. Make
sure the data types are the same.

--
Duane Hookom
MS Access MVP
--

I have a report which has many records for each File # and need to add a
subreport because the data I need to display on the report has only 1
record
for each File #. I have inserted the subreport with the links as follows,
but I cannot get any of the data from the subreport to display on my
report.
What am I doing wrong?

Child Field: File #;C Month (This comes from a Table)
Master Field: File #;Month (Main report - data from qry)

 

[Duane Hookom]

How about adding []s around C Month since there is a space and also aroun
Month since it is the name of a function?

--
Duane Hookom
MS Access MVP

Hi Duane,
I have changed the links to the following and also verified the data types
are the same, but still receive no data for my subreport. Do you have any
other suggestions?

Child Field: [File #];C Month (This comes from a Table)
Master Field: [File #];Month (Main report - data from qry)

I would expect that since you (or someone else) has chosen to use symbols
and/or spaces in field/column names, you need to enclose these in []s.
Make
sure the data types are the same.

--
Duane Hookom
MS Access MVP
--

I have a report which has many records for each File # and need to add a
subreport because the data I need to display on the report has only 1
record
for each File #. I have inserted the subreport with the links as
follows,
but I cannot get any of the data from the subreport to display on my
report.
What am I doing wrong?

Child Field: File #;C Month (This comes from a Table)
Master Field: File #;Month (Main report - data from qry)

 

[Guest]

I have made these changes and still no data. I created a query from the
table I was using for the child fields and that worked. Thank you for your
help!

How about adding []s around C Month since there is a space and also aroun
Month since it is the name of a function?

--
Duane Hookom
MS Access MVP

Hi Duane,
I have changed the links to the following and also verified the data types
are the same, but still receive no data for my subreport. Do you have any
other suggestions?

Child Field: [File #];C Month (This comes from a Table)
Master Field: [File #];Month (Main report - data from qry)

I would expect that since you (or someone else) has chosen to use symbols
and/or spaces in field/column names, you need to enclose these in []s.
Make
sure the data types are the same.

--
Duane Hookom
MS Access MVP
--

I have a report which has many records for each File # and need to add a
subreport because the data I need to display on the report has only 1
record
for each File #. I have inserted the subreport with the links as
follows,
but I cannot get any of the data from the subreport to display on my
report.
What am I doing wrong?

Child Field: File #;C Month (This comes from a Table)
Master Field: File #;Month (Main report - data from qry)