Brian,
Thank you. The numbers were out of sync because they had been exported
and imported. Your outline brought back what commands I needed to enter
into the report definition.
I have another issue which I would be grateful for some guidance:
I have a field which is formatted as A2, and contains 1, 2, 3, 4, 5, 6,
8, 9, 10
In a second field I wish to select information from a third field based
on whether the second field has a 1, 2, etc in it , but when I enter
If p1f1 = "10" then p1f3 endif
I get the selection for the A2 field whether it is "1" or "10". Is it
possible to set up the If statement that only "10" entries are selected?
Victor Warner.
Brian Hancock wrote:
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
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
