Pull calculated fields from one report to another

[c02homer]

Access 2003

I have a report with several calculated fields in group footers. Is
there a way - or is it possible - to access the results of those
calculations in a different report? (It needs to be a straight Access
process as I do not know how to use VBA.)

What I have tried so far:

I tried using a query to get the same calculations, but that requires
that I pull up two other existing queries that use the same table and
have the same fields. I need to pull the fields from both queries (the
queries compare results in the table) into the third query and even
though they are properly identified as being from query A or query B,
it says that the field names are ambiguous. So I solved it (I thought)
by using the calcuated fields in my report. But now I see that I really
need those calculations in a different report. I can't recreate the
calcuation in the new report because I'm not using the same fields.

And, so's you'll know, I tried pulling the report with the calculated
fields into a master report as a subreport, but - even though both
reports are grouped by the same unique field, the result is incorrect.
If the master report is for "John", the entire contents of the
subreport is listed under "John" and is repeated for each person's
record in the master report.

I hope that this is clear and that someone can offer some much needed
guidance!!

Thank you!!

 

[Guest]

Hi.

If you have a Report that needs to retrieve the info from the "ControlName"
control on another report named "ReportName", use:
Reports!ReportName.ControlName

For more info on this, see the following link. The info here refers to
Forms, not Reports, but for the most part you can substitute Main
Report/Subreport for Main Form/Subform.
http://www.mvps.org/access/forms/frm0031.htm


-Michael

 

[dbahooker]

if you were using Access Data Projects instead of silly little mdb; you
could setup calculated fields on the tables themselves; and then you
could re-use them wherver you want.

MDB is for babies.

-Aaron
ADP Nationalist

 

[c02homer]

Thank you for your help - I have never used an Access Data Project -
sounds intriguing - And I'm WAY to old to be a baby, but I am a bit of
an Access novice since I only get to use it on occasion and that makes
for poor skills building.

But I will definitely see if I can figure out the Data Project aspect
for future use.

In the meantime, I'm going to use Michael's method - THANK YOU,
MICHAEL!!

And thanks to EVERYONE who helps on these user groups!!!
C.