Calcualtion between Reports and Subreports

[Ely]

Hi

How can I make calculations between a Report and a Subreport. Let me
know.

Thanks,
Ely

[Dennis]

On Apr 8, 7:57 am, "Ely" <[e-mail]:

Hi

How can I make calculations between a Report and a Subreport. Let me
know.

Thanks,
Ely

Ely,
I am not very knowledgable about Access but one thing I noticed is
that the record in the subreport (assume datasheet view) is still
active when you return the cursor to the main form. Thus, if you want
to use a value on the subform you can. For example, in my case I
wanted to have a button on the main form that would pull data based on
a value in the subform record. It worked fine. If you need to use a
total from the subform then you have to create a DSUM. I don't think
this is difficult but I have never used this so good luck.

[engles]

On Apr 8, 5:57 am, "Ely" <[e-mail]:

Hi

How can I make calculations between a Report and a Subreport. Let me
know.

Thanks,
Ely

>From a subreport to get data from the parent report, use the parent

property in code -
e.g. xyz = me.parent.control + 4

>From report to get data in subreport (hmmm, I've not done this for

reports, just for forms, but expect it to be the same:
zyx = me.subreportcontrolname.report.controlname - 4

Hope this is what you are looking for.

-- Larry Engles