create Number fields
are used to store numeric data: the digits 09, a decimal point, and a sign (
). You use a Number field when you want to be able to
In the Define Database dialog box (see page 10), enter Bond_Denomination in the Field Name box, select Number from the Type drop-down list, and click Create. Repeat this procedure to create the other Number fields in the table.
create Date fields
are used to record dates. Although you could use a Text field to store dates, only a Date field will
Create the Date fields as you did the Text and Number fields; that is, enter a field name, select Date as the field type, and click Create.
FileMaker Pro supports two kinds of calculations: within individual records and across multiple records. Each is handled by a different field type.
Within-record calculations are accomplished using Calculation fields . A formula can combine other fields, constants, and built-in functions. For example, you could create a Calculation field that computes sales tax by multiplying an invoice total by a sales tax percentage ( Total * Tax Percent ) or by a constant ( Total * .075 ). The computed sales tax would be different for each invoice. Calculations can be performed on Number, Text, Date, Time, or Container fields; the specified result must also be one of these data types. If you change the data in any field on which a calculation is based, the result is automatically recalculated. Unlike other field types, the result in a Calculation field cannot be edited. (You can copy the result, but you can't change it.)
Calculations that are computed across all or a subset of records in the database are performed using
. Although Summary fields can be placed in data entry layouts, it's more common to use them in reports (as we'll do in the Investment Minder
The table below shows the
Note: An asterisk ( * ) in a formula means to multiply.