query help -
11-18-2003
, 12:23 AM
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 |