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
|