Home » Developer & Programmer » Reports & Discoverer » Passing values between workbooks
Passing values between workbooks [message #198852] Wed, 18 October 2006 18:36 Go to next message
dcolpo
Messages: 2
Registered: October 2006
Junior Member
I'm trying to build a 2 stage query. For example, I know what fruit people eat. I want to know what other fruit those people who eat bananas eat. My 1st workbook has a query to select those people who eat bananas. I want to then pass those peoples names to the second workbook query which asks the original database to return all of these peoples info, regardless of the fruit.

Report message to a moderator

Re: Passing values between workbooks [message #198999 is a reply to message #198852] Thu, 19 October 2006 10:19 Go to previous messageGo to next message
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
You can't do that between different workbooks (as far as I know, that is). But can do it whithin a workbook, so between different sheets. If you lookup subquery in the reference, you'll find what you need.

Regards,
Sabine

Report message to a moderator

Re: Passing values between workbooks [message #199005 is a reply to message #198999] Thu, 19 October 2006 10:32 Go to previous message
dcolpo
Messages: 2
Registered: October 2006
Junior Member
skooman,

Thanks for the tip. I'll do some research later today. Just knowing it's possible is very valuable. At least this way I know I'm not spinning my wheels on a dead end.

Dave

Report message to a moderator

Previous Topic: RESPONSIBILITY DOES NOT SHOW UP IN DISCOVERER DESKTOP
Next Topic: Convert decimal to standard time
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 14:38:02 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.