Chapter
1: The Basics
Once understood, most common functions are easy to use. Expressions
can define calculations or combine fields with text, always
following a consistent format throughout the program.
Chapter
2: Character Functions
From changing the case of a letter to creating expressions for
importing data, character type functions can manipulate both
simple and complex data.
Chapter
3: Date and Time Functions
Dates can be formatted in a variety of styles. One date subtracted
from another, results in the number of days between the two.
You can also calculate the time worked by an employee or show
the duration of time of sporting event.
Chapter
4: Numeric Functions
From simple arithmetic to advanced calculations, numeric functions
give superior results.
Chapter
5: Functions for Filtering and Ordering
Records
Whether locating a single record within tens of thousands or
printing a monthly sales report, filtering is at the heart of
your application design.
Chapter
6: Summary and Report Functions
Totals, averages, counts and other summaries will have your
reports telling the whole story for you and your clients.
Chapter
7: Lookup Function
The Lookup function requires more documentation than other functions
because the syntax can be hard to understand. After doing the
exercise and reading the principles behind its setup, just use
the worksheet at the end of the chapter and you'll easily add
lookups to your application!
Many thanks to Frances Peake for her assistance with this
chapter.
Chapter
8: Table Information
You can return the name of the table, the record number and
other information about fields and tables.
Chapter
9: Master Chart
When you know the name of the function, come here for quick
reference to the syntax.
|
