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
Operators
Using Calculations - 228
Operators
Operators represent mathematical, comparison, logical, and text
operations to be performed within a calculation. You must have an
operator between fields in a calculation.
For example, a calculation for a
To tal
field
might look like this:
[Price1] + [Price2] + [Price3]
The plus signs between the field names are the
Addition
operators in the
calculation.
The calculation could also look like this:
Sum([Price1],[Price2],[Price3])
The parentheses are the operators in the calculation. Commas, although
not operators, also separate the fields.
You must insert the proper parentheses, brackets, and commas when
you create a function manually or OmniForm will not accept the
calculation. See “Calculation Guidelines” on page 9-226 for detailed
information.
OmniForm automatically inserts commas, parentheses, and brackets
when you create a calculation with the Calculation Builder or the Auto
button, and when you click the Accept Calculation button.
Operator Buttons
See “Calculation Overview” on page 9-221 for instructions on creating
calculations.
Addition
Left
Parenthesis
Equal
Subtraction Not
Equal
Division
Power of
Concatenate Greater
Than
Less Than
Right
Parenthesis
Logical
And
Less Than or
Equal To
Greater Than
or Equal to
Logical
Or
Logical
Not
Multiplication