Paradox Community

Items in pnews.paradox-dos

Subject:too clever?
Date:Wed, 10 Mar 2021 07:38:48 +1000
From:Bernie van't Hof <onrequest@somewhere>
Newsgroups:pnews.paradox-dos
atable | A/C#  | Amt      | otherCols |
        | CHECK | CALC SUM |           |

Result:
One row per A/C# being total of Amt for that A/C#
Beautiful.

Change CHECK to CHECKPLUS. Likely select additonal columns

Result:
For EVERY table row, A/C# and Sum for that A/C#.
Handy sometimes, back in the day. Really?

But a bit too clever. Repeating summary data amongst source data is BAD.
And converting it is difficult, so I won't! I'm going to error it.

- Bernie


Copyright © 2004 thedbcommunity.com