Hi Victor,
There are a couple of ways, one way is:
Run a report on the panel that holds the total and in the Report body
include:
*Zeroing a Report Variable to act as an accumulator
*Include a Sub Report(s) with the panel(s) containing the totals linked to
the parent panel
*Add/Subtract whatever the values to be totalled to the accumlator
*Exit the subreport
*Store the accumlator RV into the Totals field on the parent panel
You shoud check to see why the values are out of sync, if it just because
you exported and imported all the records from a table but made a mistake
regarding the totals, then not so bad... but if it from a logic error, (not
easy to do but can happen) then you should try to rectify it
Bye
Brian
----- Original Message -----
From: "Victor Warner" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Sunday, July 22, 2007 9:17 AM
Subject: [Dataperf] realigning totals in anothers
I have a database with some fields in one panel being added to added to a
field in another panel (keep a total).
The totals in the other panel for some records are no longer accurate.
I would like the other panel fields which hold the totals to be set to
zero and then the totals added back. I asked this question a number of
years ago but cannot find the answer anymore. I would be grateful on
knowing how to do this again.
Victor Warner.
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
