dbTalk Databases Forums  

query help

comp.database.ms-access comp.database.ms-access


Discuss query help in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Brian
 
Posts: n/a

Default 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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.