User manual
Table Of Contents
- Bento® 3
- Welcome to Bento
- Overview of Bento
- Using Libraries
- Using the Address Book, iCal, and iPhoto Libraries
- Using Collections
- Using Form View
- About Forms
- Viewing a Form and a Table at the Same Time
- Creating Records in Form View
- Editing Records in Form View
- Duplicating Records in Form View
- Deleting Records in Form View
- Creating Forms
- Deleting Forms
- Duplicating Forms
- Renaming Forms
- Adding Fields to a Form
- Tabbing Between Fields
- Moving Fields and Objects on Forms
- Resizing Fields and Objects
- Removing Fields from a Form
- Customizing Form Layouts
- Using Table View
- Using Grid View
- Using Fields
- Importing, Exporting, and Printing
- Backing Up and Restoring Information
- Using Bento with Bento for iPhone and iPod touch
- Keyboard Shortcuts
- Reverting to a Previous Version of Bento
- Index
Chapter 6 Using Table View 73
Depending on the field type, the following summary functions are available.
You can use the Count function on any type of field. You can use the Sum, Average,
Minimum, and Maximum functions on fields of the following types: Number, Currency,
Duration, Rating, Automatic Counter, and Calculation (when the result is number,
currency, or duration). You can also use the Minimum and Maximum functions on
Date and Time fields.
To calculate a summary for a column:
Click in the summary row of the selected column, then choose a function from the
pop-up menu. The name of the function and the results are displayed in the summary
row.
When you do a search or an Advanced Find, the summary is recalculated based on the
records that are found.
Name Purpose
Sum Calculates the total of the values in the selected field
Count Reports the number of items that have an entry in the selected field
Average Reports the average of the values in the selected field
Minimum Reports the lowest value of the values in the selected field
Maximum Reports the highest value of the values in the selected field
Choose Sum in the summary
row to calculate the total of
the amounts listed in the
Budget column.