Skip to Main Content
Access 2002 Programming by Example
book

Access 2002 Programming by Example

by Bob Villareal
January 2002
Beginner content levelBeginner
576 pages
13h 23m
English
Que
Content preview from Access 2002 Programming by Example

Understanding Grouping and Sorting

The Group By clause in Access queries provides a quick and easy way to run aggregate calculations, such as totals, on groups of like values. The DSUM function in Excel is the counterpart to a Sum calculated with the Group By clause in an Access query. However, this function is cumbersome when compared to ease of running its counterpart in Access. You could sort and subtotal in Excel, but again, the Access method is more streamlined.

In Table 4.3, notice that there are two losses for both Florida and Colorado. Because the AccidentState field has the like values and the Incurred field has the values you want to add for a total, place the Group By clause in the AccidentState field and the Sum aggregate calculation ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Access 2003 Programming by Example with VBA, XML, and ASP

Access 2003 Programming by Example with VBA, XML, and ASP

Julitta Korol
Microsoft® Access® 2010 Programmer's Reference

Microsoft® Access® 2010 Programmer's Reference

Teresa Hennig, Rob Cooper, Geoffrey L. Griffith, Jerry Dennison

Publisher Resources

ISBN: 0789725940Purchase book