Multiple Queries

[Richard]

Is there anyway to attach multiple queries to a Report?
Or at least pull fields from multiple queries?

 

[Rebecca Riordan]

The easiest way is to use sub-reports, one for each query.

HTH

--
Rebecca Riordan, MVP

Seeing Data: Designing User Interfaces
Designing Relational Database Systems, 2nd Edition
www.awprofessional.com

Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step
www.microsoft.com/mspress

 

[Richard]

Thanks, but alas, this doesn't address my needs

-----Original Message-----
The easiest way is to use sub-reports, one for each query.

HTH

--
Rebecca Riordan, MVP

Seeing Data: Designing User Interfaces
Designing Relational Database Systems, 2nd Edition
www.awprofessional.com

Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step
www.microsoft.com/mspress




.

 

[Lauri]

Depending on what you need -
1. You can create another query that pulls all the queries together into
one.
2. You can use sub reports to put all the info you need into one report.

-Lauri