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

Taking Charge of Grouping and Sorting

The most common need for totals in the report is for groups of like values. For example, if you were in the insurance business, you might want to see all the claims for a particular year. If you were in sales, you might want to see the sales totals per region. Grouping gives you this capability. If you group by state, you might want to sort those groups. Within each state group you might want to sort the ZIP codes. This is a multi-level sort, which you can look at as a sort within a sort.

If you wanted to group all the values for a particular year in a query, you obviously have a problem if your date field is the value to group by. You will not have like values in that field because the dates will be distributed ...

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