|Subject:||Re: too clever?
|Date:||Tue, 9 Mar 2021 21:48:31 +0000
|From:||Michael Kennedy <Info@KennedySoftware.ie>
On 09/03/2021 21:38, Bernie van't Hof wrote:
> atable | A/C# | Amt | otherCols |
> | CHECK | CALC SUM | |
> One row per A/C# being total of Amt for that A/C#
Yep - very common query... no issues...
> Change CHECK to CHECKPLUS. Likely select additonal columns
> 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.