How do you link master fields to child fields

[SinginVic]

I have a master report that has 3 subreports - the last one is a new one that
I just added - I cannot see where you link the fields from the subreport to a
field on the main report . . . I'm sure this is probably really easy - so
please forgive my ignorance but I cannot find anywhere how to link these - I
did use the subreport button to specify which report - but it is not linking
the field that I want it to use.

 

[Duane Hookom]

The subreport control properties include the Link Master/Link Child
properties. This is the exact same as what you would find on a subform
control.

 

[SinginVic]

Ok - now I found that and it is linked on the right field but the data is not
matching up to the field that is the control - different totals are coming
out on the wrong pages -
all I want to do is get totals for two expressions in each of the first two
subreports and add them together at the bottom of the report - but I cannot
get it two work -
I probably don't have them grouped together correctly but when I do the
subreport by itself - it sorts the data correctly . . .


--
Vicki K
Portland Oregon

The subreport control properties include the Link Master/Link Child
properties. This is the exact same as what you would find on a subform
control.

 

[Duane Hookom]

We don't know where your totals are or how they are calculated. You may need
to place your main report totals in the section containing the subreports
and then use a running sum on these text boxes.

--
Duane Hookom
MS Access MVP

Ok - now I found that and it is linked on the right field but the data is
not
matching up to the field that is the control - different totals are coming
out on the wrong pages -
all I want to do is get totals for two expressions in each of the first
two
subreports and add them together at the bottom of the report - but I
cannot
get it two work -
I probably don't have them grouped together correctly but when I do the
subreport by itself - it sorts the data correctly . . .

 

[SinginVic]

I think it may have something to do with the fact that sometimes there is no
total - "Null" so now I need to figure out how to to this formula -
=([Subrept Stmt-Q1Pledge.Expr1]+[Subrept Stmt-Q1Other.Expr1])

with the possibility of either one of these Expr1 totals being null.

 

[Duane Hookom]

Search this News Group on
HasData
This will allow you to use the IIf() function with the HasData property of
the subreport.

--
Duane Hookom
MS Access MVP
--

I think it may have something to do with the fact that sometimes there is
no
total - "Null" so now I need to figure out how to to this formula -
=([Subrept Stmt-Q1Pledge.Expr1]+[Subrept Stmt-Q1Other.Expr1])

with the possibility of either one of these Expr1 totals being null.

--
Vicki K
Portland Oregon

We don't know where your totals are or how they are calculated. You may
need
to place your main report totals in the section containing the subreports
and then use a running sum on these text boxes.