2.0
Table Of Contents
- Introduction
- Installation and Setup
- Tutorials
- Views and Form Usage
- OmniForm Procedures
- Designing a Form
- The Design Process
- The Design View Toolbars
- Creating Objects
- General Creation Guidelines
- Creating a Text Object
- Creating a Line Object
- Creating an Oval Object
- Creating a Rectangle Object
- Creating a Graphic Object
- Creating a Fill Text Object
- Creating a Comb Object
- Creating a Check Box Object
- Creating a Circle Text Object
- Creating a Table Object
- Creating a Fill Graphic Object
- Defining Objects
- Changing Object Appearance
- Redesigning Your Form
- Using the Scrapbook
- Inserting OLE Objects in a Form
- Filling a Form
- Managing an OmniForm Database
- Using Calculations
- Calculation Overview
- Operators
- Functions
- Abs (Absolute Value)
- Avg (Average)
- Date (Current Date)
- DayName
- DayOfMonth
- DayOfWeek
- DayOfYear
- Exp (Exponentiation)
- FV (Future Value)
- Hour
- If
- Int (Integer)
- Left
- Length
- Ln (Natural Logarithm)
- Log (Base 10 Logarithm)
- Lower
- Max (Maximum)
- Middle
- Min (Minimum)
- Minute
- Mod (Modulus (Remainder))
- Month
- MonthName
- Pi
- PMT (Payment)
- Position
- Proper
- PV (Present Value)
- RecordCount
- Replace
- Replicate
- Right
- Round
- Second
- Sign
- Sqrt (Square Root)
- Sum
- Time
- Trim
- Trunc (Truncate)
- Upper
- Year
- Functions — Quick Reference
- Functions Sorted by Type
- Technical Information
- Glossary
Calculation Overview
Using Calculations - 224
Suppose you wanted to create a calculation for a
Subtotal
field in an
invoice. The
Subtotal
field is the sum of the
Price1
and
Price2
fields. There
is often more than one way to create a calculation. Here are two
calculations you could create:
• [Price1]+[Price2]
• Sum([Price1],[Price2])
Both calculations return the same result. The first calculation is simple
addition. It is easy for new users to create.
The second calculation uses the
Sum
function and is more complex than
the first calculation. This calculation is useful for adding multiple fields
because you do not need to place the Addition operator between them.
OmniForm automatically inserts the necessary parentheses, brackets,
and commas when you create a calculation using the Calculation
Builder. See “Calculation Guidelines” on page 9-226.
Auto Calculations
To create an auto calculation, OmniForm looks for such common field
names as
Quantity, Price, Total,
and
Sum.
It also determines calculations
based on field type, field names, and column header labels. If you
selected a field named
To tal ,
for example, OmniForm would look for
fields above the
To tal
field to sum.
This is one reason it is important for fields to have unique names. See
“Defining Objects” on page 6-20 for detailed information.
1 Select a fill text, comb, check box, circle text, or table object in
your form to activate the toolbar.
A calculation appears in the calculation text box if one was
defined for this object before. If so, proceed to step 4.
2 If no calculation appears, click the
Auto
button in the
calculation toolbar.
A message tells you if no auto calculation could be created. See
“The Calculation Builder” on page 9-222 if OmniForm could
not create a calculation and you want to create your own.