Usenet.com

www.Usenet.com

Group Index

Comp Thread Archive from Usenet.com

<-- __Chronological__ --> <-- __Thread__ -->

query help



Hope this makes sense -

I'm trying to figure out how to store the result of 1 query for use as the
criteria for a second query?

I'm trying to take a sum [qrySumofTotalStartWatts].[SumOfTotalStartWatts]
and use it as the criteria in the query "qrySelectGeneratorKw"

The query works but it prompts me for SumOfTotalStartWatts.  How do I run
the first query and get the result into the criteria for the second query?

I'm so confused I can't even put a coherent question together!!!!
HELP!!!!!!!!!!!

Thanks in advance for any help you can provide

Brian





<-- __Chronological__ --> <-- __Thread__ -->


Usenet.com



Please check out one of the premium Usenet Newsgroup Service Providers below for access to Usenet.