On Thu, 2006-12-07 at 12:48 +0100, Frank Schönheit - Sun Microsystems Germany wrote: > Hi Brian, > > > Is there an easy way to pass a single parameter value to multiple > > queries? > > Of course there is: Double-click every query, and enter the same value > all the time. > > Well, what I wanted to say :) is that your scenario is a little bit > underspecified. What exactly are you doing? Programmatic execution of > queries? Programmatic execution of the underlying statements? If so, in > a RowSet or a Form? Or do you want to open multiple queries in the UI, > but only be asked once?
Hi Frank- Sorry, I will explain further. One and two but not three, unless there is some magic wand I can wave that does not require programming. I have six queries that each have two parameters, start date and end date. These queries form the basis of a report. (I'm using Calc, but if there is a better way I'm open to it). Each query sits on a sheet; all I did was drag a query into the sheet using F4. When I want to run the report, I save with a new name and do a Data/Refresh Range on each sheet, which triggers the parameter dialog. I'd like to be able to specify the date range once and have the start and end dates propagate to all queries without having to cycle through each sheet, do a refresh, and re-enter the dates. Doesn't matter to me if the parameter is obtained via a single dialog or reading off of a calc cell. It would be nice if I could specify a default date based on the current date. Blue skies, -B > The answer to your question depends on what exactly you want to do ... > > Ciao > Frank > -- Brian Jamison OpenSourcery Founder Technology for Good (503) 544-3558 http://opensourcery.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
