| AGECALC.FP3
- A handy calculation for determining ages. |
|
|
| AlphaNum
- Determines whether the entry in a field begins with a letter or
a number. |
|
|
| BirthCalc
- Determines the age of a person. |
|
|
| Birthday.fp3
- A calculation to show age in years, months, and days. |
|
|
| CalcDates
- Several calculations for dates, like the last day of next month,
and the next closest Friday. |
|
|
| CALCS
- 65 indispensable calculations from John Mark Osborne. 4 free with
the demo. |
|
|
| CalcTime
- Determines the amount of time between two times, even if they cross
multiple days. |
|
|
| CaseChoose.fp3
- A file that shows you how to use the CASE statement function. |
|
|
| CheckText
- Converts numbers to text for use with a check writing program. |
|
|
| DaysPast
- This technique was developed for a pilot who needed to track the
number of hours he flew each month. A multi-key relationship is used
to track the hours for the current month. |
|
|
| Decimal
- This tip demonstrates how to validate a number field to require
2 or less decimal places. |
|
|
|
|
| Decimals
to Fractions - Converts decimal numbers to fractions. |
|
|
| Dollars
- This file contains the calculation necessary to convert a decimal
value into a text equivalent. Useful for printing checks. |
|
|
| EZ
Lookups - EZ Lookups illustrates a simple way to use a few field
calculations and some easy scripting as a front end to initiating
a series of lookups for a group of fields. |
|
|
| FindMonth
- Finds all the records from the past month or the current month,
without any user input (see the calculations in Define Fields). |
|
|
| FormTel
- Formats foreign telephone numbers. |
|
|
| Hotel.fp3
- Shows how to search a database for reservations. |
|
|
| LapsTime
- This file has many calculations to help you track elapsed times. |
|
|
| MONDAY1
- Calculates the date of the first Monday of the following month. |
|
|
| msqldate.zip
- Converts dates to Unix format and back to Julian. |
|
|
| No.
To Word - Converts numbers to words for a check writing system. |
|
|
| Num2Frac.fp3
- This handy little learning tool shows you how to convert decimal
numbers to fractions with a minimum of fields. |
|
|
| One
Field Calendar Calc - Very interesting approach to creating a
calendar. Also shows simple text animations. |
|
|
|
|
| Ordinal
- Shows a calculation for adding the correct ordinal value to a number
(e.g. 3rd). |
|
|
| Overdue
- Shows the proper way to locate overdue invoices. Techniques utilizing
the Today function in a calculation slow down a database significantly. |
|
|
| Parse2.fp3
- Here is a great tip file that demonstrates how to parse an address
field into separate fields using the Return character as a delimiter.
Learn how powerful the Position, Middle, and PatternCount functions
can be. |
| |
| Parse
Out Returns - This technique uses the Middle and Position functions
to demonstrate how to parse hard returns out of a text field with
a script. |
|
|
| Position
- Compares the speed differences between using the Case or If statement
vs. the Position function. Both calculations result in the same value,
but the Position version is much faster. |
|
|
| Substitute
- This is a neat little trick for utilizing the Substitute (text,
search string, replace string) function to print out only those items
that have been checked. |
|
|
| TimeConv
- Converts time entries to just minutes and seconds. |
|
|
| TimeDif.zip
- Figures the difference between times over multiple days. Two approaches
are shown. |
|
|
| Times
- A file that allows you how to enter times in 24-hour format without
colons and have it converted to a time field. Great for speedy data
entry. |
|
|
| Unique
Tester - Shows you how to compare the result of a calculation
to the rest of the records in the database. In other words, it checks
for duplicates. |
|
|
| Validate
Calculation - Shows you how to validate a calculation field as
being unique. This particular file validates a concatenated name. |
|
|
| WeekMonth
- Determines what week of the month a date falls in. |
|
|
| Y2K.zip
- Forces data entry to 4 digit years to prevent problems with 2 digit
years. |
|
|
Calculations
