View Full Version : Referencing another report in new report


grub1609
05-04-2006, 01:37 PM
I have created a report that sums values of certain data. I want to take the summed value from the first report and use that value in another report. Is there a way to do this. Basically, how do I point the control source of a text box in one report from an already created report. Thanks for the help.

Smart
05-05-2006, 03:12 AM
You could create a new query that references the query that the first report is based on and also references the query the second report is based on
(don't forget to link the queries.

You should now be able to manipulate the data to your requirements