Database Reference
In-Depth Information
Figure 5.13
Ta b u l a r d a t a v i e w o f the 0-10 query
Step 4: Create Additional Queries
1.
Mouse over
Query Explorer
and click on the
Queries
folder.
To speed up the development of this report, we will copy the
0-10
query to create the
additional two queries for the union.
2.
Select the
0-10
query, and click on the
Copy
button on the toolbar (or press Ctrl+C on
the keyboard).
3.
Click on the background area of the
Query Explorer
design window (any whitespace)
and click on the
Paste
button on the toolbar twice (or press Ctrl+V twice).
4.
This action creates two new queries and their initial names are 0-11 and 0-12.
5.
Rename query
0-11
to
11-20
.
6.
Rename query
0-12
to
More than 20
.
7.
Drag the
11-20
query to the bottom query reference window to the right of the union icon.
8.
Drag the
More than 20
query below the
11-20
query within the same union.
HINT
Yo u w i l l g e t a n i n s e r t i o n p o i n t .
Yo u r q u e r y d e s i g n w i n d o w s h o u l d n o w l o o k s i m i l a r t o t h e d e s i g n s h o w n i n F i g u r e 5 . 1 4 .