Register and Join the most happening forum of Sikh community & intellectuals from around the world.
Discussion in 'Information Technology' started by Keensie, Jul 28, 2006.
What's a summary query?
They are used to give a total or sub total of field
You can use a summary query to show/display SUMMARY INFORMATION
To create one you can use the wizard â€“ 1st choose the table and then click
the new items dropdown and choose SUMMEARY as the query type.
Click the â€œgroup byâ€ icon at the top of the screen
Next, specify groups by choosing the column(s) by which you want to group
Note that rows that have the same value stored in the group field are
When the value of the field changes, a new group begins.
You can have many levels of group fields. You can then aggregate data by
groups from the â€œsummary iconâ€.
You can calculate a total, a count, the minimum, the maximum, and the
average for a column by groups. For example, you may want to total income by
a (an aggregate) by salesperson (as an aggregate or total) or within a region
OR both (this would be shown as 2 two levels of groups).
Best bet would be to press F1 and search the help files for more info
Hope this helps
> What's a summary query?