2.0

Managing Database Records
Managing an OmniForm Database - 203
Sorting Records
You can sort records in OmniForm in ascending, descending, or original
order entry. This is useful for many situations. If you wanted to export
mailing information, for example, you could sort records by postal code
to reduce bulk mailing costs. Or, you might want to sort invoices by date
to find the most delinquent accounts.
You can print, fax, mail, or export this information in the order in which
it is sorted.
To sort records:
1 If you are in design view, click the Fill button in the standard
toolbar or choose
Fill
in the View menu to switch to fill view.
2 Choose
Sort...
in the Records menu.
The Sort dialog box appears.
3 Select the field by which to sort in the
Field Name
drop-down
list.
All the fields in your form are listed here.
To make sorting as easy as possible, give each field a unique name
after it is created. Otherwise, you could have fields named
FillText1
,
FillText2,
and so forth, making it difficult to figure out which fields
contain what information. See “Defining Objects” on page 137 for
detailed information.
4 Select a sort order.
•Select
Ascending Order
to sort records from least to greatest;
for example, from A–Z or from 0–100. Symbols precede
numbers which precede letters: $40, 40, Forty
.
•Select
Descending Order
to sort records from greatest to least;
for example, from Z–A or from 100–0. Letters precede
numbers which precede symbols: Forty, 40, $40
.