Re: Subreport

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Frye (Frye_at_discussions.microsoft.com)
Date: 01/25/05 

Date: Tue, 25 Jan 2005 11:27:05 -0800

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" wrote:

> 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" <Frye@discussions.microsoft.com> wrote in message
> news:991D049E-DB3C-4A0F-8998-96A682FB3F78@microsoft.com...
> > 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)
> >
> > "Duane Hookom" wrote:
> >
> >> 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" <Frye@discussions.microsoft.com> wrote in message
> >> news:3C13234A-7904-4809-B738-93ACEC1388F3@microsoft.com...
> >> >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)
> >> >
> >>
> >>
> >>
>
>
>

Quantcast