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
data.
Note that rows that have the same value stored in the group field are
grouped together.
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).
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/9312-summary-query.htmlReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9312
Best bet would be to press F1 and search the help files for more info
Hope this helps
"Keensie" wrote:
> What's a summary query? 
Our Donation Goal
: Why Donate? : Donate Today! : Donate Anonymously (ਗੁਪਤ) : Our Family of Supporters 
Linear Mode
