Re: Selecting Specific Member in MSQuery

["Roger Pence" <rp@xxxxxxxxxxxxxx>]

-----Original Message-----
From: John Cirocco <JCirocco@gw.ctg.com>
To: MIDRANGE-L@midrange.com <MIDRANGE-L@midrange.com>
Date: Wednesday, February 17, 1999 1:31 PM
Subject: Selecting Specific Member in MSQuery


>Hi folks,
>
>   I currently use Excel (with MS Query) to retrieve data from the /400 to
create performance graphs.  I currently have a routine that copies the data
out to a work library so that I only have one member per performance data
file.  Is there a better way?  Is there a way so select a member within the
SQL that MS Query generates?
>
>Thanks in advance.

Having thought about your problem, have you thought about using Project
Lightning to do what you want to do? Lightning can be called from an Excel
macro and does a good job of getting data into Excel (especially,
well-scoped result sets). Although it's relatively easy, it's relatively
nerdy. Let me know if you'd like to see an example.

rp

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---