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 - 241
Mod (Modulus (Remainder))
The Mod function returns the remainder of a number or numeric
expression divided by another number or numeric expression. A
positive number is returned if the dividend is positive, and a negative
number is returned if the dividend is negative.
Usage Example
Mod([dividend num],[divisor num])
If the numbers in the fields are 87 and 8
Then the calculation Mod([dividend num],[divisor num]) returns 7 (87 ÷ 8 = 10
with a remainder of 7)
In the example below, the number of computer disks remaining after
packaging full boxes is placed in the
Remaining
field.
Month
The Month function returns the number of the month for a given date.
The month ranges from 1 to 12.
Usage Example
Month(Date())
If the current date is February 14, 1996
Then the calculation Month(Date()) returns 2
In the example below, the month is put in the
Current Month
field using
the current system date calculated in the
Present Date
field.