Thread: How to count negative numbers
View Single Post
  #7 (permalink)  
Old July 6th, 2009, 09:21 AM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,516, Level: 42
Points: 9,516, Level: 42 Points: 9,516, Level: 42 Points: 9,516, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,060
Thanks: 0
Thanked 10 Times in 10 Posts
Default
The very simplest way is to open the other report as acHidden, and then take the values from the report control. Make sure the On Close event of your visible report closes the other report. I would use 2 copies of each report: Deviation, Deviation_Hidden, Numbers, Numbers_Hidden, just so there is no overlapping code.

The most elegant way to do this is to create public function in a module that gathers that data regardless of where the call is from. So the control on the Numbers report would be: fnDeviation(), and vice versa.

I always use ADO since I always do Access / SQL, so maybe Greg's code would work best for this.

Did that help?
__________________
mmcdonal

Look it up at: http://wrox.books24x7.com
Reply With Quote