Subject: | Re: too clever?
| Date: | Tue, 9 Mar 2021 21:48:31 +0000
| From: | Michael Kennedy <Info@KennedySoftware.ie>
| Newsgroups: | pnews.paradox-dos
|
On 09/03/2021 21:38, Bernie van't Hof wrote:
> atable | A/C# | Amt | otherCols |
> | CHECK | CALC SUM | |
>
> Result:
> One row per A/C# being total of Amt for that A/C#
> Beautiful.
Yep - very common query... no issues...
> Change CHECK to CHECKPLUS. Likely select additonal columns
>
> Result:
> For EVERY table row, A/C# and Sum for that A/C#.
Yep, but kinda pointless:
- Either leave the 'Calc Sum' (with no CHECK/CHECKPLUS in the Amt field),
- Or drop a CHECK or CHECKPLUS into the Amt field, and drop the Calc.
> Handy sometimes, back in the day. Really?
Makes no sense to me - see above. But, maybe a leftover from someone
adjusting old code (badly)?
> 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.
All agreed.
- Michael
|