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 - 223
•
Functions
list
This list contains all available functions that can be used in a
calculation. (Functions are sorted by category in Windows 95.
Click a category to open it.) Double-click a function to insert it
in the calculation text box, or select it and click
Paste
.
See “Functions” on page 9-230 for detailed information.
2 Select the operators, fields, and functions that you need for
your calculation.
3 Click the Accept Calculation button to define the calculation on
the field and close the Calculation Builder dialog box.
• A calculation is defined on the selected field when you click
the Accept Calculation button. OmniForm performs the
calculation automatically in fill mode when the appropriate
fields are filled.
• You can click the Cancel Calculation button to clear the
calculation text box or to revert to the last accepted
calculation.
• You can manually delete entries in the text box and click the
Accept Calculation button if you want to clear the box
entirely. This is useful if clicking the Cancel Calculation
button causes it to revert to a previously accepted version.
4 Click the Calculation button in the standard toolbar or choose
Calculation
in the Tools menu to close the calculation toolbar.
Closing the toolbar also accepts the current calculation.
Operators
List of available
functions.
List of fields in your form