Using a Single Item Query Return as Query Criteria

[lotharious]

I have a query that returns a PO# only.
I need to be able to use this po# as a criteria in a later query

so it would look something like
select sum(Amount) from table where po > [return po# from query]

 

[jebry]

Hi!

Use your query as a subquery:

select sum(Amount) from table where po > (What you put in here is the SQL for your subquery that will return a single value)

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[lotharious]

Hmm.. tried that was giving me errors, will try it agian so see if I can get it to work.

 

[jebry]

Hi!

If you want to post all of the sql for your query we will see if we can help.



Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[lotharious]

I got it to work.. not sure how I screwed it up...