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
Functions
Using Calculations - 239
Max (Maximum)
The Max function returns the maximum (highest) value of a set of
numbers and/or numeric expressions.
Usage Example
Max([num1],[num2] ...)
If the numbers in the fields are 150, 200, and 45
Then the calculation Max([num1],[num2],[num3]) returns 200
In the example below, the
Top Sales
field displays the highest sales made.
Middle
The Middle function returns the characters from a given string
beginning at a specified starting position from the left in the string, and
continuing to the right for the specified number of characters. The first
(beginning) position in the string is 1.
Usage Example
Middle([str1],start position number,number of characters)
If the field [str1] = 2/14/96
Then the calculation Middle([str1],3,2) returns 14
In the example below, the
Middle
and several other functions extract the
last name from the
Full Name
field and place it in the
Last Name
field.
Refer to these other functions elsewhere in this section for more
information.