|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 16th, 2004, 07:44 PM
|
|||
|
|||
Multiple Queries
Is there anyway to attach multiple queries to a Report?
Or at least pull fields from multiple queries? 
|
|
#2
August 16th, 2004, 08:52 PM
|
|||
|
|||
|
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" wrote in message ... Is there anyway to attach multiple queries to a Report? Or at least pull fields from multiple queries?
|
|
#3
August 16th, 2004, 09:23 PM
|
|||
|
|||
|
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 "Richard" wrote in message ... Is there anyway to attach multiple queries to a Report? Or at least pull fields from multiple queries? .
|
|
#4
August 16th, 2004, 11:26 PM
|
|||
|
|||
|
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 "Richard" wrote in message ... Is there anyway to attach multiple queries to a Report? Or at least pull fields from multiple queries?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Combining multiple select queries into one select | Andrea | Running & Setting Up Queries | 1 | August 4th, 2004 03:37 AM |
| Executing multiple statements in queries | Don | Running & Setting Up Queries | 1 | July 12th, 2004 03:08 PM |
| Exporting Multiple Queries to 1 Excel Workbook with VBA | Anthony | Running & Setting Up Queries | 2 | June 3rd, 2004 07:59 PM |
| Date Range in Multiple Queries | James Stephens | Running & Setting Up Queries | 1 | June 2nd, 2004 12:10 AM |
Linear Mode
