Subreport

  • Thread starter Thread starter Guest
  • Start date Start date
G

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)
 
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.
 
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)
Click to expand...

Duane Hookom said:
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
--

Frye said:
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)
Click to expand...
Click to expand...
 
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


Frye said:
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)
Click to expand...

Duane Hookom said:
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
--

Frye said:
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)
Click to expand...
Click to expand...
Click to expand...
 
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!

Duane Hookom said:
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


Frye said:
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)
Click to expand...

Duane Hookom said:
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)
Click to expand...
Click to expand...
Click to expand...
 
Back
Top