I have two reports - Report 1 lists "projects" based upon a query. Report 2 lists the details of the project and I would like this report generated based upon the results of the query in Report 1. How can I do this or where can I find instructions on how to do this??? I've looked through the User Manual, on-line, etc. and don't see a solution. Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Create one query based on results of another query
- Thread starter meyerz
- Start date
Hello meyerz,
You cannot use the data displayed in a report (column) directly as input to another query. You can however call a subquery IN a query definition by using a condition in the main query like:
object equal to <<Create a subquery (ANY)>> or:
object in list <<Create a subquery (ANY)>>
from the operands panel.
The SQL structure will then look like:
Select a,b,c,
From X
where D =
(select .... from ....) T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com
You cannot use the data displayed in a report (column) directly as input to another query. You can however call a subquery IN a query definition by using a condition in the main query like:
object equal to <<Create a subquery (ANY)>> or:
object in list <<Create a subquery (ANY)>>
from the operands panel.
The SQL structure will then look like:
Select a,b,c,
From X
where D =
(select .... from ....) T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question