Thanks Tim
That solved it nicely.
Michael
Tim Rude wrote:
Michael,
I'm thinking that perhaps a 'two-level-report' based on the Receipt
Number field might be in order here.
Tim Rude
----- Original Message -----
*From:* Michael Iannantuoni <mailto:[EMAIL PROTECTED]>
*To:* DataPerfect Users Discussion Group
<mailto:[email protected]>
*Sent:* Sunday, May 13, 2007 11:30 AM
*Subject:* [Dataperf] Detecting duplicates
I have just finished redesigning the payments panel (now a single
panel covering both advertisers & subscribers) of our village
magazine database. I am pleased with the end result and it much
simpler & more flexible than the old system, however there is one
minor problem I would like to resolve within DataPerfect.
One report lists details of payments by Receipt Number order but
yesterday an advertisers paid a very late bill (£100) and a new
one (£121) with a single cheque of £221. We want to keep the two
transactions as separate entries but have assigned them the same
Receipt number, again something we would wish to stick with.
When the report is run, the two "duplicate" Receipt Number entires
list with their details correctly and at the moment I have a
Report Variable assigned the Receipt Number after each record and
the next Record Number is compared with that. If there is a match
then the word "Duplicate" (in bold) is added after the second
occurrence of that Receipt Number. When the report is imported
into WordPerfect for final formatting & printing, I can locate it
and edit things so that the two entries appear under one Receipt
Number heading with both sets of details and a Total of £221, in
this case as the amount paid.
if P2F5 is the Receipt Number field:
RV1 is assigned - if P2F5 = RV2 then "Duplicate" else ""
endif
P2F5 RV1
Name Field
Date
Amount
RV2 is assigned - P2F5
I realize that while the report is running, I can't detect a
duplicate until after the first one has been processed all I can
do is flag the second occurrence as described.
This is an unusual occurrence and hopefully won't happen often so
I am happy to resolve things within WordPerfect but does anyone
have any ideas as to how it night be tackled within DataPerfect
please?
Michael
------------------------------------------------------------------------
_______________________________________________
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
