Is it possible???

[Chris-eh]

Is it possible to pull a calculated field from one report into another report. I know you can set it to sum as =[Reports]![Levels of Access Rpt]![AccessRating] or something like that it should identify that field in that report but I get ERROR#

or can you take a calculated field and get it into a query?

I'm trying to create a summary report of another report which currently pulls all information based on the parameter of what one record you choose.
This summary report will show all records with the rating associated from the original report.
Can you do this?
Thanks

 

[Rich]

Create a totals query with the same parameters, base the second report on that.

 

[Chris-eh]

umm? not the same; let me be more specific...

The field was created in the one report as a calculated field in the report, it sums other calculated fields in the report that are counting yes answers of fields being pulled from a query with a parameter that when you run this report it wil ask you for what record to pull yes's and only bring up the preview for that record.

This final sum report field I want to pull the answer from it and put it in another report that shows for all records and there related final sum answers. Does this clarify?