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 - 221
Calculation Overview
This section gives an overview of how to create calculations. It contains
the following topics:
• Creating a Calculation
• Calculation Guidelines
• Using the Recalculate... Command
• Usage Conventions
See “Tutorial 3 — Create Your Own Form” on page 3-34 for step-by-step
instructions on creating a simple calculation.
Creating a Calculation
Calculations are created in design view. You can create a calculation for
fill text, comb, check box, and circle text objects.
You must open the calculation toolbar to begin.
To open the calculation toolbar:
1 If you are in fill view, click the Design button in the standard
toolbar or choose
Design
in the View menu.
2 Click the Calculation button in the standard toolbar or choose
Calculation
in the Tools menu.
The calculation toolbar appears.
3 Select a fill text, comb, check box, circle text, or table object in
your form to activate the toolbar.
The calculation toolbar contains four buttons and a text box.
• Cancel Calculation button
Click this to revert to the last calculation accepted. The text
box clears if no version was accepted.
• Accept Calculation button
Click this to accept the calculation in the text box.
Click to Edit Calculation — the calculation
for the selected field appears here.
Accept
Calculation
Cancel
Calculation
Calculation
Builder
Auto
Calculation