4.0

Managing Database Records
Managing a Database 49
If another new calculation was added to the same expense form and you
recalculated all records, the mileage rates on your old records would
also change. They would then be incorrect. To prevent this, you could
search the records for those records newer than the date that you
changed the mileage calculation, and apply the new calculation only to
the newer records.
See ”Searching Records for Information” on page 43 for information on
searching.
You cannot recalculate records if data protection was turned on in the
form in the OmniForm program. Contact your OmniForm administrator
or the form’s creator if you need data protection turned off.
To recalculate records:
1 Choose
Recalculate...
in the Records menu.
The Recalculate dialog box appears.
2 Select the records to recalculate.
• Select
All Records
to apply the new or changed calculation to
either the current found set or to every record in the database
if the entire record set is open.
• Select
Current Record Only
to apply the new or changed
calculation to just the record you are viewing.
• Select
From/To
to apply the new or changed calculation to a
range of records.
Enter a number in the
From
and
To
text boxes. If you entered
1 in the
From
text box and 5 in the
To
text box, for example,
OmniForm Filler would recalculate the first five records in
your database or found set.
You cannot undo a recalculation!
3 Click
OK.