Query based on the results of another query?

Hello,

I have a query that contains an ADO record set (query1) from a table. I
would like to create a second query (query2, that happens to be a View)
based on the results of query1. Both queries share the same OrderId.

What I am trying to do is say something to the effect:

Select *
From View
Where OrderId = (the results from query1)

It would also be desirable to have query2 sorted in the same order a query1.

Any help would be appreciated.

Thanks in advance,

Dave.


.

Relevant Pages

  • Re: SubQuery or SubReport??
    ... when running the report. ... Since you join on GPP, not on CompanyName, query3 should be: ... SELECT query3.gpp, query1.*, query2.* ...
    (microsoft.public.access.queries)
  • Re: How do you pass parameters between queries in Microso
    ... It sounds like you might have one query that depends on the ... and two queries (QUERY1, QUERY2). ... user retrieves formatted records within a particular date range by ... QUERY1 references the text boxes in FORM1 where a data range is entered. ...
    (microsoft.public.access.queries)
  • Re: Calculate a percentage using 2 different query totals
    ... FROM query1, query2; I assume it is code or an expression to be written some ... "Duane Hookom" wrote: ... >> Is there any way to calculate and display, in a query or report, a ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Using UNION with three queries
    ... Obviously, none of these is a complete query statement, but I'm just giving ... FROM Query1 AS A LEFT JOIN Query2 AS B ... FROM Query1 AS A RIGHT JOIN Query2 AS B ...
    (microsoft.public.access.queries)
  • Re: Extremely slow IN clause
    ... How much time it takes to run the Query2? ... time for each possible value of Query 1). ... the only way I could find to incorporate Query2 into Query1 is to use ... > returns over 4500 records in less than a second; adding the IN clause ...
    (microsoft.public.access.queries)