SQL Hacks: Tips & Tools for Digging Into Your Data by Andrew Cumming & Gordon Russell

Author:Andrew Cumming & Gordon Russell [Cumming, Andrew]
Language: eng
Format: azw3
Tags: COMPUTERS / Database Management / General
ISBN: 9780596102555
Publisher: O'Reilly Media
Published: 2006-11-20T16:00:00+00:00

Figure 8-2. Creating a view with Query Builder in Access

Tip

In the Access Query Builder, you can create a GROUP BY query using the Totals toggle (this button is marked with a sigma [S]). When the totals toggle is on you get an extra line labeled Total in the lower pan. In the totals line you can choose to perform a SUM, COUNT, GROUP BY, or WHERE on each column.

At this stage, you can run and test the query. It will use the parameters specified in the param table.

Once you have a query that is displaying the data you want to appear in the report, you can start to build the report. Take care that you have included all the data you need, because the next step is the Report Wizard, shown in Figure 8-3. If you go back and add or remove columns from the query after you’ve created the report you will find that the report won’t run properly. It is hard to fix a formatted report, so your best bet is to create a new report from scratch by running the Report Wizard again.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.